formulas
 

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?

formulas
 

looopy;238966 Wrote:
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?

Try the SUMIF function or a Pivot Table


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=66722

formulas
 

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
---
"looopy" wrote:
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?