Count three things, two of which are from the same column
Hi,
I’m hoping someone can help me on a formula I need in my calculation sheet that counts items from 2 columns within a different sheet. My formula was working until we decided to include more than one status in the count from the second column.
Here’s the formula that was working until I needed to also include a second status in the count:
=COUNTIFS({Country}, "Indonesia", {Status}, "Live project”)
I’d like to adapt/add to the above so that the output also counts Re-prints from the Status column. I've figured out a workaround by counting them separately and then feeding the sum to where I need it but I realise that this will be a simple fix for someone with a better understanding than mine, and I'd like to keep my calc sheet clean and efficient if possible.
I hope this makes sense. Any help would be much appreciated.
Many thanks,
Lee
Best Answer
-
Try this formula
=COUNTIFS({Status}, OR(@cell = "Live Project", @cell = "Re-prints"), {Country},"Indonesia")
Answers
-
Try this formula
=COUNTIFS({Status}, OR(@cell = "Live Project", @cell = "Re-prints"), {Country},"Indonesia")
-
Hi @Lee5
Something like this perhaps?
=COUNTIFS({Country}, "Indonesia", {Status}, "Live project”, {Status}, "Re-prints”)
https://www.linkedin.com/in/zchrispalmer/
-
Hi @JamesB thanks for that. Works! Fantastic.
Thanks, @Mr. Chris I thought your suggestion would also work but the count came back as zero. I might be wrong, but I'm thinking that one counts only if Live Project and a Re-print whereas I wanted to count 1 for either status.
Thank you both for your time.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!