Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF & IF
On column A I have dates (mmmm dd, yyyy), on column B I have names (John Doe)
and on column C I have ammounts ($0.00). On a seperate worksheet inside the same workbook, I would like to sum the ammounts per name, if they equal to =Today(). For example, A B C 1 July 20, 2009 John Doe $20 2 July 20, 2009 Jane Doe $10 3 July 28, 2009 John Doe $5 4 July 28, 2009 John Doe $20 5 July 28, 2009 Jane Doe $30 6 July 28, 2009 Jane Doe $10 July 28, 2009 ( =Today() ) John Doe - $25 Jane Doe - $40 Hope I got my idea through.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
Help with SumIf | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |