Case Sensitive in SUMIF

[sushilkumar1990]

Hi,

I want to use SUMIF in a cell for Case sensitive case. Eg:

Service 10
service 20
Service 30
service 40

I want the sum of "service" = 60 and Service = "40".

Note: I do not want to use helper row or column or array formula, or SUMPRODUCT.
It should be a cell formula using sumif or sumifs.

 

[bobhc]

I think you are in for a life of missery useing Excel if you want 40 to equal 60, you will spend all your time looking for input mistakes.

 

[Colin Legg]

SUMIF text comparisons are case insensitive so this cannot be achieved per your requirements. You either need to use a helper column or an array/SUMPRODUCT formula.

 

[ANKUSHRS1]

for this use sumproduct formula...

=SUMPRODUCT(--(EXACT(A7,A2:A5)),B2:B5)