If Formula

[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

Someone here told me to use this formula

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

It works, but I am only getting a total for column G and
nothing for K is there another way to enter it.

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

 

[Biff]

Hi Kevin!

Here are a couple of examples.

Enter either of these formulas in the following cells:

E112 =SUMIF(C2:C7,"A",G2:G7)+SUMIF(C2:C7,"A",K2:K7)
E113 =SUMIF(C2:C7,"B",G2:G7)+SUMIF(C2:C7,"B",K2:K7)
E114 =SUMIF(C2:C7,"C",G2:G7)+SUMIF(C2:C7,"C",K2:K7)
E115 =SUMIF(C2:C7,"D",G2:G7)+SUMIF(C2:C7,"D",K2:K7)

OR......

These are array formulas and must be entered with the key
combo CTRL,SHIFT,ENTER:

E112 =SUM(IF(C2:C7="A",G2:G7+K2:K7))
E113 =SUM(IF(C2:C7="B",G2:G7+K2:K7))
E114 =SUM(IF(C2:C7="C",G2:G7+K2:K7))
E115 =SUM(IF(C2:C7="D",G2:G7+K2:K7))

In either formula it would be easier to use a cell
reference for the letter.

Biff

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((C1:C110="A")*(G1:K110))

 

[Biff]

What if columns H,I, and J have numeric values ?

Biff

 

[Biff]

=SUMPRODUCT((C1:C110="A")*(G1:K110))

=SUMPRODUCT((C1:C110="A")*(G1:G110+K1:K110))

Biff