Countifs Function Not working

Elizabeth Creager

So, I've been working on this for a day. I have a headache lol. Can someone take a look at this formula and make suggestion as to what I'm missing?

=COUNTIFS({Staff}, "Name", ({Event Type}, "Sale")

I'm using 2 columns of data and want to do a count using Name and type of sale condition. Suggestion?

Genevieve P.

Hi Elizabeth,

It looks like you might just have an extra parenthesis in there... try this:

=COUNTIFS({Staff}, "Name", {Event Type}, "Sale")

If this doesn't work, it would be helpful to see a screen capture of the sheet you're referencing (but please block out any sensitive data).

Thanks!

Genevieve