WeegyAVLover
Distinguished Member
Hi All,
Need help getting a excel formula to work as I expect it to. I currently have this formula:
I have knocked up a quick formula table below to show an example of what I am doing and what I am getting:
The results I get are for Row 2 the formula gives the total of 60 (row2 columns C, D, E added together) which all looks good.
However for Ro3 I get the answer of 30 because it is only adding column D once and ignoring there are 2.
Does that make sense?
I cannot seem to figure out what I am missing. Any advice?
Need help getting a excel formula to work as I expect it to. I currently have this formula:
I have knocked up a quick formula table below to show an example of what I am doing and what I am getting:
A | B | C | D | E |
1 | 10 | 20 | 30 | |
2 | =SUMIF($C2:$E2,">=1",$A$1:$E$1) | 1 | 1 | 1 |
3 | =SUMIF($C3:$E3,">=1",$A$1:$E$1) | 1 | 2 | 0 |
4 | ||||
5 |
The results I get are for Row 2 the formula gives the total of 60 (row2 columns C, D, E added together) which all looks good.
However for Ro3 I get the answer of 30 because it is only adding column D once and ignoring there are 2.
Does that make sense?
I cannot seem to figure out what I am missing. Any advice?