sum row formulae between dates

[Gerry]

I am struggling!! (yet again).
I am trying to automate a spreadsheet linked to other data
sources.
The worksheet has dates as column headers.
On various rows I have sub totals.
I am trying to create a formulae to sum (a defined single
row) between dates (referenced elsewhere).
Any suggestions?

 

[Frank Kabel]

Hi
if your date values are in row 1 (starting in B1) and you
want for example sum row 10 try:
=SUMPRODUCT(--(B1:X1>=DATE(2004,1,1)),--(B1:X1<=DATE
(2004,3,31)),B10:X10)

You can replace the hardcoded dates with a cell reference

 

[Gerry]

Gr8 Result.
Again Frank. Thank you

-----Original Message-----
Hi
if your date values are in row 1 (starting in B1) and you
want for example sum row 10 try:
=SUMPRODUCT(--(B1:X1>=DATE(2004,1,1)),--(B1:X1<=DATE
(2004,3,31)),B10:X10)

You can replace the hardcoded dates with a cell reference


.