Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |