Sumproduct

[Zot]

Discussion split from this thread: ADD A RANGE OF CELLS FROM MULTIPLE COLUMNS BASED ON CRITERIA FROM ONE COLUMN

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I also suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.


Try

=SUMPRODUCT((F5564:F5568="CC")*EL5564:EP5568)

This formula works in 365? This is good. I'm still in 2016

 

[Zot]

Those are not in the same format as my formula. Look more closely.

Yes. I noticed that

Sorry, I missed that post when making my last one. No you cannot, because SUMPRODUCT can only work with numbers, not TRUE/FALSE values which must be coerced to numbers.
You could use commas like this

=SUMPRODUCT(--(C15:C17="CC"),E15:G17)

I aware about using --(C15:C17="CC") but it still did not work

Book1.xlsm
	C	D	E	F	G
15	CC		100	0	0
16	CA		0	100	0
17	CC		0	0	100
18
19			#VALUE!
20			200
Sheet8

Cell Formulas
Range	Formula
E19	E19	=SUMPRODUCT(--(C15:C17="CC"),E15:G17)
E20	E20	=SUMPRODUCT(--(C15:C17="CC")*E15:G17)

 

[Peter_SSs]

but it still did not work

Actually, it doesn't for that arrangement.

BTW, I am going to move our discussion to a new thread as the OP's thread has been hijacked by it.