How to ignore blank date cells in sumproduct
Thanks for the reponse Mike.
I have...
CODE ORDER DATE COST
CS01 7-Jan-08 £200.00
MT03 14-Jan-08 £4000.00
MT03 (blank) £500.00
This is a shortened example
The formula is fine but my problem is when a cell in the date column is
blank it assumes that it is the 00-Jan-00 and totals up the data in my
January totals Table.
I would like it to ignore the blank cells. Is this Possible?
"Mike H" wrote:
Hi,
I can't make that formula misbehave, it looks fine to me can you give the
precise circumstances under which you get an error.
Mike
"Phil_S" wrote:
I have a worksheet in which I am tring to sum the data based upon a code
range, a date range and cost range. However when I enter this formula it sums
the data from blank cells into the cell i wish to sum all the costs for
January.
=SUMPRODUCT(--($B$2:$B$268=$U277),--(MONTH($D$2:$D$268)=8),($K$2:$K$268))
Is there any way around this?
|