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