Hi,

I am looking for idea, how to add up cell range a1:a3 based on the values in b1:b3 and c1:c3

A B C D
1 3 A S =SUMIFS(A1:A2,B1:B2,"S",C1:C3,"<A") =4
2 4 S Z
3 5 Z A,S Looking to formulate the above formula to arrive same answer.

In D3, I need to write the formula in such way it takes the character A from C3 to calculate the sum.

In another word, how to find the character from cell range