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!”
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