Sum If

[Parra]

OK, here is the info. Its better if I show you and then explain.

Column A, Column B, Column C
10L, data, data
5I, data, data
6I, data, data
5I, data, data
10L, data, data
etc., data, data
Sub Total for each of the 3 variable in column A

Column A, Column B, Column C
10L, data, data
5I, data, data
10L, data, data
5I, data, data
6I, data, data
10L, data, data
etc., data, data
Sub Total for each of the 3 variable in column A

Grand Total

In the sub total, I only want the numbers to add if they match for example only those that have 5I in column A, etc. And then the grand total to all the subtotals for 5I,6I and 10I.

Can someone please help me, with a formula.

 

[Aladin Akyurek]

=SUMIF(A2:A100,"5L",B2:B100)

would total the data in B that correspond to a "5L" in A.

Aladin