Excel 2003, accepting valued for calculation based on adjacent cell

[network_engineer]

Hi all,

So, this IS different from the other question. And I will try my best to describe this as accurately as possible. Apologies if I don't come across clear!

I have two columns, C and D, with rows 4 through 65536. And I will have a SUM of all values from column D. I.e. D3, will be a sum of values from D4:D65536, i.e. D3 =SUM(D4:D65536)

C will have values (personally defined) from a list, such as H, N, L (High, Nominal, Low); however, I want that D3 would be a sum ONLY if the respective adjacent cell in C would be H.

E.g.

C4 = H, D4 = 1;
C5 = H, D5 = 1;
C6 = N, D6 = 1;
C7 = H, D7 = 1;
C8 = L, D8 = 1;
C9 = H, D9 = 1;
---------------
D3 = 4

A normal sum of D4:D9 should be 6; however, based on C6 and C8, the values are not taken into account.


Thanks a lot.

Kind regards.

 

[Peter_SSs]

Try

=SUMIF(C4:C9,"H",D4:D9)

 

[VoG]

Perhaps

=SUMIF(C4:C65536,"H",D4:D65536)

 

[network_engineer]

Hi again,

Edited under: //I suppose the formula goes into D3; however, it says the formula has an error! I tried playing around, but did not help. Any ideas?//

Edited later: Oops, my mistake, it worked perfectly! Thanks again!

Kind regards,
Ben