User Profile
Stephen_Pisano
Copper Contributor
Joined Feb 07, 2020
User Widgets
Recent Discussions
Re: Totalling a column that includes an ‘IF’ formula that produces a number
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!Re: Totalling a column that includes an ‘IF’ formula that produces a number
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? SteveTotalling 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 total the ‘1s the outcome is alway 0. The only way I have discovered to total the column which counts the ‘1s’ is by =SUM(P20+P21 etc) which is time consuming and problematic when adding new rows. Any suggestions out there?
