Hi all,
I'm having difficulty in adding a condition to this formula:
=SUMPRODUCT($N$4:$N$2000,--(TEXT($B$4:$B$2000,"MMM")=AR5),--(TEXT($B$4:$B$2000,"YYYY")=TEXT(AS5,0)))
All I want to is add the condition that if AR2 is the range I5:I2000.
Im getting errors all the time. I thought it would have been something simple like this:
=SUMPRODUCT($N$4:$N$2000,--(TEXT($B$4:$B$2000,"MMM")=AR5),--(TEXT($B$4:$B$2000,"YYYY")=TEXT(AS5,0)),--(I5:I2000,$A$2)))
That doesn't work, so any help would be grateful as I'm sure that its a simple mistake I have made.
Cheers
I'm having difficulty in adding a condition to this formula:
=SUMPRODUCT($N$4:$N$2000,--(TEXT($B$4:$B$2000,"MMM")=AR5),--(TEXT($B$4:$B$2000,"YYYY")=TEXT(AS5,0)))
All I want to is add the condition that if AR2 is the range I5:I2000.
Im getting errors all the time. I thought it would have been something simple like this:
=SUMPRODUCT($N$4:$N$2000,--(TEXT($B$4:$B$2000,"MMM")=AR5),--(TEXT($B$4:$B$2000,"YYYY")=TEXT(AS5,0)),--(I5:I2000,$A$2)))
That doesn't work, so any help would be grateful as I'm sure that its a simple mistake I have made.
Cheers