Sumif exact number only

Hello all,

How do I write a formula to say SUMIF the following cells contain 5:

O45, Q45, S45, U45? They will either all contain either 0 or 5

I just want a formnula to sum all 4 cells to add wherever there is a 5, so the total might be 0, 5, 10, 15, or 20.

Thank you

=SUM(O45,Q45,S45,U45)

or have I completely misunderstood??

Sorry Glenn, my apologies I forgot to say each of the cells contain a formula: =IF(T45=$U$44,"5","0")

so using the sum formula is returning a 0.. hence why i thought i need a sumif? i'm doing this in a google sheet

=IF(T45=$U$44,5,0)

The " " are turning the numbers into text.

oK is there an recommendation on how to overcome this please? i've tried to change the formatting of the cells

Does this:

=IF(T45=$U$44,5,0)


and this

=SUM(O45,Q45,S45,U45)

together, not work?

It works fine for me on GS. I have no idea how to save it and share it though...

Does this link work?

https://docs.google.com/spreadsheets...it?usp=sharing

that helps thank you!

Is that you sorted? If so, I'm off for a beer before dinner!