Adding up 2 columns

  • Thread starter Thread starter Gord
  • Start date Start date
G

Gord

Ok, the subject line might not be accurate... I have a spreadsheet
with worksheets for each month that we track the sales of several
people on.

I want to make a grid that outputs the count of each type of
transaction, but seperated by name. For example


John Jan Feb
A 4 6
B 7 18

Jane Jan Feb
A 4 6
B 7 18

In a prefect world I will code all but the results, and the results
would update automatically. Is there any easy ways to do this?
 
What does a typical "month" sheet data layout look like?
best wishes

--
Bernard Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme










- Show quoted text -
Click to expand...

Each Month has 9 or 10 columns with different info of the item in each
column (date, transactio ntype, model sold, etc)
 
Back
Top