countifs for three separate things

Julzbrownlie · 01/27/25

I am tying to count if three criteria is being met. See data

I want to know how many

steak pies there are in price region 1 with price band 1?

I have tied countifs but it's just not working, any help would be appreciated.

Paul Newcome · 01/27/25

What happens if you get rid of the 1 after the first "description"?

Paul Newcome · 01/27/25

What is the COUNTFS you have tried so far?

Julzbrownlie · 01/27/25

=countifs(descreport:descreport,descreport@row,description1:description,"Takeaway")

Paul Newcome · 01/27/25

What happens if you get rid of the 1 after the first "description"?

Julzbrownlie · 01/28/25

That works thanks you very much, I tried so many different thing and something as simple as forgetting to take the 1 out!

Paul Newcome · 01/28/25

Happy to help. 👍️

Best Answer