Forum Discussion

Stephen_Pisano's avatar
Stephen_Pisano
Copper Contributor
Feb 07, 2020

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...
excel
Formulas and Functions
Dennis_Galvan1's avatar
Dennis_Galvan1
Copper Contributor
Feb 08, 2023

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)

Resources