Forum Discussion
Totalling a column that includes an ‘IF’ formula that produces a number
15 Replies
Our online community's mission is to provide a platform for IT administrators, developers, MVPs, and Microsoft employees to interact. We want Tech Community to be a one-stop shop for product newshttps://laptopwise.com/accessories/ best practises, and thought leadership.Stephen_Pisano
Good morning, Stephen
I have looked at several sites, and your previous help to others, but I am unable to solve my problem, and I was hoping you could help.
I have a working "if" statement but have not figured out how to get the resulting numeric place in another cell for eventual summation for a total.
My present statement starts with columns A, B (formula), F (cost) and I am trying to get a number value (cost) in C to be able to tabulate at the end of the column!
cell a5 which activates the formula with an "x" (otherwise nothing), my formula goes into b5 which returns the numerical value or 0 =IF(A5="x";1*F5;0) I need to finish this statement but have not discovered how after several hours.
All the videos I watch give all kinds of "how to do different scenarios" but don't seem to address my specific need, albeit, I may have missed it.
I am 77 years old, and used to have more command of how to do various statements, but my previous knowledge seems to be lost to time! 🙂 Your help would be greatly appreciated!
Dennis Galvan
214-460-7497 (text or call)
- 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
- Your second suggestion worked perfectly thank
you! - Thanks for your suggestions- I will give them a try Asap
- You might have this issue if the returned 1's are text rather than a number - does your formula resemble this:
=IF(true_value, "1", "0") - The speech marks denote that the results would be text and would not be summed.
=IF(true_value, 1, 0) - This version would return numbers as a result and can be summed.
If you can share a copy of your workbook we can take a look.- Hi there, I tried =SUMPRODUCT(P20:P45*1) and it works perfectly. Thanks for your suggestions.
- Thanks for your suggestion- I will give a a try ASAP
