# Get instant live expert help on sum if cell contains

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Need to sum cell values IF they are adjacent to a cell which contains certain text (trying to quickly sum the totals of categories by category name)
Solved by F. B. in 22 mins
I need a formula that states if Cell C contains 0 then Cell D = 0 but if Cell C contains any number greater than 0 then Cell D will equal the sum of Cells A and B
Solved by V. S. in 12 mins
How do I get a cell value to equal zero in a sum function if it contains text?
Solved by M. S. in 12 mins
i need help with a formula. Example cell 1a contains "x" Cell 1b Contains =sum 2a(5):2c(5) Which equals 10 i want cell 2b to be "if cell 1a contains "x" then cell 2c = # inputed-2 so the end value would be 8 how do i word this as a formula?
Solved by B. D. in 23 mins
I need one colums sum if the adjacent column contains 1, or 0
Solved by E. H. in 20 mins