If Formulas

[Kevin]

I need some help. Here is what I am trying to do
In column C I have entered the letters a, b, c or d.
In column's G and K I am entering a number.
I would like E112, E113, E114 and E115 to keep running
total's of columns G an K

For example

Column A Column C Column G Column K

Jan 1 A 2.2 3.1
Jan 2 B 4.0 2.2
Jan 3 A 1.0 3.0
Jan 4 C 6.2 5.1
Jan 5 D 3.0 1.3
Jan 6 D 2.9 5.8

If column C = A I would like a running total of G and K
in E112
If column C = B I would like a running total of G and K
in E113
If column C = C I would like a running total of G and K
in E114
If column C = D I would like a running total of G and K
in E115

Thanks
Kevin

 

[Myrna Larson]

Do you really want to get the totals by the letter in column C? If so, have
you considered a Pivot Table?

If you don't want to do that, assuming the data goes to row 110, in E112

=SUMIF(C1:C110,"A",G1:K110)

In the formulas in E113:E115, replace the "A" with the correct letter.

 

[Kevin]

Thanks, that helps a bit but when I use that formula,
=SUMIF(C1:C110,"A",G1:K110)it is only adding up column G
and not K