sumproduct not working
Still returns the #VALUE error.
My formula in column F is
"=IF(D3<VAT!$N$26,-4,IF(D3VAT!$N$26,MONTH(D3),0))"
Column D is a date in format dd/mm/yyyy entered by user. VAT!$N$26 is a
number equivalent of a date ie 38838
If I reduce the length of the column ranges from 1500 to 900 so that they
only include rows with data entered it works, but obviously i need to
prepare the sheet for use from new, i.e. with no data in at least some of
the rows. Could I add a rider to limit the row length to only completed rows
perhaps?
Thanks again
"Teethless mama" wrote in message
...
=SUMPRODUCT(ISNUMBER($F$3:$F$1500)*($F$3:$F$1500={ 5,6,7})*($L$3:$L$15000)*($M$3:$M$1500))
"Tester" wrote:
Hi this is my formula
=SUMPRODUCT(--($F$3:$F$1500=(OR(5,6,7))),--($L$3:$L$15000),$M$3:$M$1500)
but it returns zero value and i'm guessing its the OR function, but how
can I work around this please?
TIA
Chris
|