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...
Sergio, I have a new problem that you may be able to solve. I have a new column that relates to a set of individuals. When their scores increase from one test to another I insert a + in the column. When they decrease insert a -. I want to be able to create two formulas in two cells adjacent to the column of +s and -s, one that will give me the number of +s and one for the -s. Is this possible do you think? Steve
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!!!
