Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of amount with corresponding dates
Column C is full of $ amounts billed and the corresponding date (same row)
in column E reflects the date that bill was paid. I want to write a formula that will Sum the numbers in column C adding each row ONLY if it has an actual date on the same row in column E AND only if that date is in 2009. Is this even possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of amount with corresponding dates
Try this:
=SUMPRODUCT(--(YEAR(E2:E100)=2009),C2:C100) -- Biff Microsoft Excel MVP "Great13" wrote in message ... Column C is full of $ amounts billed and the corresponding date (same row) in column E reflects the date that bill was paid. I want to write a formula that will Sum the numbers in column C adding each row ONLY if it has an actual date on the same row in column E AND only if that date is in 2009. Is this even possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of amount with corresponding dates
Try something like this adjusted for a reasonable range:
=SUMPRODUCT(--(YEAR($E$1:$E$1000)=2009),$C$1:$C$1000) Does that get you started? -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Great13" wrote: Column C is full of $ amounts billed and the corresponding date (same row) in column E reflects the date that bill was paid. I want to write a formula that will Sum the numbers in column C adding each row ONLY if it has an actual date on the same row in column E AND only if that date is in 2009. Is this even possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count amount of different dates & amounts of them. | New Users to Excel | |||
Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
Find dates to calculate amount of work per day? Possible? | Excel Discussion (Misc queries) | |||
Converting amount in figures to amount in words | Excel Discussion (Misc queries) |