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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks