SUM of a range conditional on date

B

bdw248

I've got 15 columns, A/c No, Description, Jan, Feb, Mar etc and YTD.
I'm wanting to sum the columns conditional to a date, ie sum(C:E)
when the date is 31/03/04.
I've been using if statements but am limited by the maximum of 7 if's
(I need 12).
I'm open to any suggestions,

Thanks

Bria
 
A

Arvi Laanemets

Hi

Maybe you are somewhat more specific. Which columns you want to sum. And how
is the date you mentioned related with data in columns to sum.

A general idea - you can sum every month separately, with some logical
conditions controlling which column is taken into account. Something like
=LogicalExpr1*SUM(Jan)+LogicalExpr2*SUM(Feb)+...+LogicalExpr12*SUM(Dec)
or
=LogicalExpr1*SUMIF(Jan,Condition)+LogicalExpr2*SUM(Feb,Condition)+...+Logic
alExpr12*SUM(Dec,Condition)
 
Top