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...
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!