What is wrong with SUMPRODUCT formula

[Sean15]

Hi:

I have in sheet named PT balances laid out as:

Col C Col D Col E

Oct 2017 $1,200.00

Nov 2017 1,000.00




I want to sum data into sheet 2 I8


=SUMPRODUCT(('PT balances'!$C$4:$C$23={"Oct","Nov","Dec"})*('PT balances'!$D$4:$D$23="2017")*'PT balances'!$E$4:$E$23)

is returning 0. Could you help me fix formula?

I had a similar formula that an OP fixed yesterday so I can't understand why this one is not returning required value.


Regards,

Sean

 

[DRSteele]

I think maybe "2017" doesn't need the quotes - ColumnD contains numbers, not text, no doubt.

 

[Aladin Akyurek]

Try rather...

=SUMPRODUCT('PT balances'!$E$4:$E$23,--ISNUMBER(MATCH('PT balances'!$C$4:$C$23,{"Oct","Nov","Dec"},0)),--('PT balances'!$D$4:$D$23=2017))

 

[Sean15]

@DRSteele - yep. Thank you so much for the assist.

@Aladin Akyurek - thanks very much.

 

[DRSteele]

You're welcome. I'm glad to have provided assistance.

 

[Aladin Akyurek]

Ditto...