pivot table grouping

[namsilat]

I like to use following example to illustrate what I am looking for. Let's say I have 3 salesperson with sales figure by month, and I have them listed as:

January
Joe $100
John $50
Jane $500

February
Joe $350
John $90

March
John $75
Jan 100

I found so far that the only way I could get it working is to have a specific column in the spreadsheet that tracks month for each person, i.e.

January
Joe $100 January
John $50 January
Jane $500 January

Is there a way to get the same result without needing that extra month column?

 

[ziad alsayed]

how your data is listed in the Sheet, try to post it, i think using SUMIF Or SUMIFS can make it.

 

[namsilat]

The names are in column A, and the dollar amount in column B. The extra month column is in C. I am not clear on how SUMIFS can eliminate the need of column C, could you elaborate further?