Help Needed with Sumifs

[Asheesh]

Hi Experts,

Please see the attached...Neither the Sumifs nor the SUM(If Array...is working in this scenario..

Note: I dont want to use helper cells...and is there a way to give the criteria as a range and not as single value...

Appreciate your help in advance....

 

[NARAYANK991]

Hi Asheesh ,

See if this works :

=SUM(SUMIFS($B$2:$B$18,$A$2:$A$18,$D$3:$D$5))

Enter this as an array formula , using CTRL SHIFT ENTER.

Narayan

 

[Khalid NGO]

recheck your name range(s)

 

[Sathish KV]

Hi,

Also try

=SUMPRODUCT(((namerng=D3)+(namerng=D4)+(namerng=D5))*(valrng))

 

[Asheesh]

@NARAYANK991 @Sathish KV

Thank you guys....suggested works like charm..

 

[Faseeh]

This one also with CSE:

=SUMPRODUCT((TRANSPOSE(D3:D5)=A2:A18)*(B2:B18))

 

[Asheesh]

Hats off to you guys.....