sum row formulae between dates

  • Thread starter Thread starter Gerry
  • Start date Start date
G

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?
 
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
 
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


.
Click to expand...
 
Back
Top