Problem with SUMIF 510 error

I have used countif successfully with the format shown in this spreadsheet, but sumif isn’t working. I would like to total column F when column E equals P and then count all others in a separate total. I have been through the documentation and a number of topics in the questions, but can’t find my problem. Formatting with and without punctuation and quotes has caused me some grief. I know this is a simple problem and appreciate any help.
2022 Sponsors.ods (28.9 KB)

Thanks but when I widen the column I get a 510 error indicating a missing variable. Not sure if anything is missing or if it is my punctuation.

Thanks for that. I figured it was my formatting. One change, in the calculation for Other, I need to total all items that do not have a P in column E (there will be some with R and some blank). I played around with it and just not well enough versed in the formatting.

I appreciate it.

Instead of <>"p", Criterion must be "<>p".

3 Likes

This will help me in the future. The answer above will solve my problem, but this was the answer I was looking for. Thanks for the additional info.