Adding a condition to SUMPRODUCT

[jack109]

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

 

[Fluff]

Try

--(I5:I2000=$A$2)

 

[jack109]

Just getting a #Value. Formula works fine on its own, just cant add that extra bit to get it to work

 

[Fluff]

It should be I4 not I5, also do you want to compare that column to A2 or AR2?

 

[jack109]

Got it to work, sorry didn't realise I had put typos in. Thanks for the help

 

[Fluff]

Glad you sorted it & thanks for the feedback.