User Profile
Dennis_Galvan1
Copper Contributor
Joined Feb 08, 2023
User Widgets
Recent Discussions
Re: Totalling a column that includes an ‘IF’ formula that produces a number
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)1.5KViews0likes0Comments
Recent Blog Articles
No content to show