network_engineer
New Member
- Joined
- May 14, 2011
- Messages
- 37
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.
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.
