SUM IF Formula

Cheryl Collins

Hi

I am trying to sum the number of days based on a criteria - I'm expecting a 6 to come back but, instead I'm getting a 0

I know its something super simple but, I've been looking at this for ages now and can't workout what the issue is!

TIA

Cheryl

Paul Newcome

You are essentially telling the formula to only pull numbers that are equal to "Office Innovations". That is definitely not a number, so there is nothing being pulled in. Try adjusting the syntax to fit the SUMIF function.

=SUMIF({range to match on}, matching criteria, {range to sum})

Paul Newcome

You are essentially telling the formula to only pull numbers that are equal to "Office Innovations". That is definitely not a number, so there is nothing being pulled in. Try adjusting the syntax to fit the SUMIF function.

=SUMIF({range to match on}, matching criteria, {range to sum})

Cheryl Collins

Hi @Paul Newcome

So, obvious now! 🙈

Thanks - thats done it!

Paul Newcome

Happy to help. 👍️