Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF across multiple worksheets | Excel Worksheet Functions | |||
Countif & Sumif with Multiple criteria | Excel Worksheet Functions | |||
How to SUMIF multiple ranges? | Excel Discussion (Misc queries) | |||
SUMIF With Multiple Criteria | Excel Worksheet Functions | |||
Is it possible to specify multiple condition with SUMIF? | Excel Worksheet Functions |