Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF/PRODUCT & DATES
Basically I have a column with various dates in, and a column next to it with
amounts in. I want make 5 formulas to calculate the sum of the amounts but only between certain dates. So for instance the first calculation would be the sum of the amounts in column B but only amounts next to dates which fall between 30/03/07 and 30/03/08 in Column A |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF/PRODUCT & DATES
u have 2 columns A n B, Date and amounts, respectively
on c1 = your start date source on c2 = your end date source on c3 = sumproduct(($A$1:$A$10=C1)*($A$1:$A$10<=C2),($B$1 :$B$10)) for the other four formula select c1:c3 copy paste to d1:g3 regards -- ***** birds of the same feather flock together.. "Sarini" wrote: Basically I have a column with various dates in, and a column next to it with amounts in. I want make 5 formulas to calculate the sum of the amounts but only between certain dates. So for instance the first calculation would be the sum of the amounts in column B but only amounts next to dates which fall between 30/03/07 and 30/03/08 in Column A |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF/PRODUCT & DATES
=SUMIF(A:A,"="&date1,B:B)-SUMIF(A:A,""&date2,B:B)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sarini" wrote in message ... Basically I have a column with various dates in, and a column next to it with amounts in. I want make 5 formulas to calculate the sum of the amounts but only between certain dates. So for instance the first calculation would be the sum of the amounts in column B but only amounts next to dates which fall between 30/03/07 and 30/03/08 in Column A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
working out quarters (three-month periods) between two dates | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |