multiple SUMIF arguments
 

Here's an example of what i want to do

i have three columns
Name of person(multiple names)/Month(every month of the year)/Sales price

I would like to be able to build a calculation that sums up the Sales prices
of John Doe for October. Sum of sales prices for Jane Doe for Nov. Ect.

Please help! Thanks

multiple SUMIF arguments
 

Hi Jess

Assuming that Names are in column A, Dates in column B and Values in
column C
Assuming you place the Name you want to find in E2 and the Month you
want in F1 in the format of 01 Oct 2006 for October
(This cell can be formatted with FormatCellsNumberCustommmm to just
show Oct if you wish)

In cell F2 enter
=SUMPRODUCT(($A$2:$A$100=$E2)
*(TEXT($B2:$B100=TEXT(F$1)*($C$2:$C$100))

If you want to add more names down through E3, E4 etc, just drag the
formula down.
Equally, if you add other month dates in G1, H1 etc. you can drag the
formula across to pick up data for other months

--
Regards

Roger Govier


"Jess" wrote in message
...
Here's an example of what i want to do

i have three columns
Name of person(multiple names)/Month(every month of the year)/Sales
price

I would like to be able to build a calculation that sums up the Sales
prices
of John Doe for October. Sum of sales prices for Jane Doe for Nov.
Ect.

Please help! Thanks