DonAndress
Active Member
- Joined
- Sep 25, 2011
- Messages
- 362
- Office Version
- 2019
- 2016
- Platform
- Windows
Hello.
I have a table like below:
<tbody>
</tbody>
I'd like to sum values from col. F, G and H only if in col D there is a value.
I use two different ways of summing the values:
straight forward:
and array:
But only array formula works correctly.
In the first example I get a sum of 444 and in the second it's 420 which is correct.
Could you please tell me what did I do wrong in the first example?
I have a table like below:
Column D | Column E | F | G | H |
% split key: | 2 | 5 | 5 | |
719 | 14 | 36 | 36 | |
% split key: | 2 | 5 | 5 | |
2 777 | 56 | 139 | 139 |
<tbody>
</tbody>
I'd like to sum values from col. F, G and H only if in col D there is a value.
I use two different ways of summing the values:
straight forward:
Code:
=SUMIF($D$7:$D$10,"<>""",F7:F10)+SUMIF($D$7:$D$10,"<>""",G7:G10)+SUMIF($D$7:$D$10,"<>""",H7:H10)
Code:
{=SUM(IF(D7:D10<>"",F7:H10,""))}
But only array formula works correctly.
In the first example I get a sum of 444 and in the second it's 420 which is correct.
Could you please tell me what did I do wrong in the first example?