This seems to work nicely,
=countifs(A:A,"large",B:B,"pizza")+countifs(A:A,"large",B:B,"pasta")
Yet putting it all in the one will not work, i.e.
=countifs(A:A,"large",B:B,or("pizza","pasta"))
Is there a way to achieve this?
Thx, MQ
This seems to work nicely,
=countifs(A:A,"large",B:B,"pizza")+countifs(A:A,"large",B:B,"pasta")
Yet putting it all in the one will not work, i.e.
=countifs(A:A,"large",B:B,or("pizza","pasta"))
Is there a way to achieve this?
Thx, MQ
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
Hi MQ,
Try: =SUM(COUNTIFS(A:A,"large",B:B,{"pizza","pasta"}))
Worked nicely!
Glad to hear it. Thanks for the rep point.
Don't forget to mark the thread as SOLVED if you're happy you have your answer.
BSB.
For not equals, which is correct?
=SUM(COUNTIFS(A:A,"large",B:B,"<>{"pizza","pasta"}"))
=SUM(COUNTIFS(A:A,"large",B:B,{"<>pizza","<>pasta"}))
MQ
Hi,
Actually that's no longer an OR statement, but an AND statement, so you need:
=SUM(COUNTIFS(A:A,"large",B:B,"<>pizza",B:B,"<>pasta"))
Regards
you can also use a pivot table for that kind of work.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks