Forum Discussion
Stephen_Pisano
Feb 07, 2020Copper Contributor
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
Feb 07, 2020Diamond Contributor
Stephen_Pisano
Feb 08, 2020Copper Contributor
Your second suggestion worked perfectly thank
you!
you!