Forum Discussion
Totalling a column that includes an ‘IF’ formula that produces a number
I have created a column of numbers, 0 or 1, that is produced with an IF command in each cell relating to an adjacent column of cells, eg O20 and so on. When I use a SUM formula eg =SUM(P20:P45) to tot...
SergeiBaklan Many thanks Sergie -that is very kind of you. I have attached a workbook that copied your suggestion but it is totalling zeros instead of the correct numbers???
Stephen_Pisano Hi Sergei - please ignore my last message - I've corrected the formula and it works perfectly - thank you again!!!
Stephen_Pisano , great, thank you for the updating us
- Hi Dennis, I’m really sorry but I have no idea as to how to solve your problem. I’ve only used the forum to get help not offer advice as I’m an occasional user of this group. If you posted your problem openly to the forum rather than a direct message I’m sure you’ll find an answer!