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

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