formulas

[looopy]

on my spreadsheet i have 3 columns; name, date, amount.
the names given are of only two people, and the sheet is in date order.

NAME DATE AMOUNT
smith 18.01.09 20
jones 19.01.09 4
smith 21.01.09 2
smith 29.01.09 3

i want to work out the overall amount for both names. how can i do this?

 

[Max]

Something like this, in say E2:
=SUMPRODUCT((A2:A10="smith")*(TEXT(B2:B10,"mmmyy")="Jan09"),C2:C10)
will return the total amount in col C for "smith" in Jan 2009. The dates in
col B need not be sorted, but must be real dates. Adapt the ranges to suit.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik