COUNTIF or COUNTSIF
I just cant seem to figure out how to work the formula I am trying to accomplish. Ive googled and watched youtube videos and its not getting me anywhere.
I have a sheet titled "reporting metrics" with three columns. I am trying to pull in data to count the totals from 3 columns from another sheet titled "install file". Two of those columns use checkboxes. I want it to count if the "install complete" column is not checked, AND if "color grouping" column is "blue" AND if "delivered to customer" column IS checked. to let me know the count remaining for each color.
I really hope this makes sense to the help me solve this. I have been trying to figure this out all day😞
Answers
-
It sounds like a COUNTIFS Function will work for you! To look for checkboxes, you'll want to use 0 to indicate "un-checked" and 1 to indicate "checked".
For example, something like this:
=COUNTIFS({Install Complete Column}, 0, {Color Grouping Column}, "Blue", {Delivered to Customer Column}, 1)
If this hasn't helped, it would be useful to see screen captures of your source sheet and the formula you've tried, but please block out sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!