IF formula

tushar

Hi Folks looking for simple formula hoping someone can help

Trying to add in sheet summary

Total cost [ sum of all amounts in last column] if Purchase order status [ first column] is 1.1

Any suggestions welcome is it better in sheet summary , reports etc

Thanks in advance

Melissa Yamada

Hi @tushar ,

I'd be happy to help!

You may try using SUMIFS function instead of an IF function. You may try this formula on your sheet summary field:

=SUMIFS([Total Cost]:[Total Cost], [Purchase Order Status]:[Purchase Order Status], "1.1")

Let me know if this works! :)

tushar

Thankyou Melissa for quick reply

No error in formula although its not adding up the amounts , value is coming zero

Melissa Yamada

Hello @tushar

If you copied the formula here and paste it on your sheet summary tab, you may want to try manually adding the formula and selecting the range and criteria range instead. Sometimes copy and paste doesn't work as expected.

Make sure as well that the "1.1" is correctly formatted as what you have on your sheet.