Does the fact that the range is generated by a function affect the SUMPRODUCT function?
In this particular spreadsheet I have used the following formula without issue:
=SUMPRODUCT(--(MONTH(Quotes!$K$2:$K3139)=8),--(YEAR(Quotes!$K$2:$K3139)=2013),--(Quotes!$F$2:$F3139))
where column F contains manually input numbers
However, when I try to use this formula:
=SUMPRODUCT(--(MONTH(Quotes!$K$2:$K3139)=8),--(YEAR(Quotes!$K$2:$K3139)=2013),--(Quotes!$T$2:$T3139))
I get a #VALUE error.
The primary difference is that the numbers in column T are generated by a formula working on other cells in the worksheet. Column T does also contain blank cells (also generated by the formula) but I have never had a problem with blank cells in my data range before so long as I use the -- syntax.
Can anyone offer any advice?
Bookmarks