Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

COUNTIF Question

I work in theatre and use numbers to keep track of microphones who's using them where they have been and what current condition they are in


I use COUNTIF to count the different tags (in use, dull, crackle, etc...) I do not know how to make the cell take into consideration the different microphone types, and colours and then separate them out into the different cells in the total pages.


There is probably an easy way to do it I just don't use numbers functions enough to know, any help would be greatly appreciated


MacBook Pro 16″, macOS 11.7

Posted on Sep 21, 2023 4:54 AM

Reply
4 replies
Sort By: 

Sep 21, 2023 6:14 AM in response to Ollie100

Consider using the SUMIFS function, something like this:




In B2, filled to C5 (in this short example):


=COUNTIFS(Microphones::$B,$A$1,Microphones::$C,B$2,Microphones::$D,$A3)


In A6, filled right and down:


=COUNTIFS(Microphones::$B,$A$1,Microphones::$C,B$2,Microphones::$E,$A6)



You can read up on COUNTIFS, with many examples, here:


COUNTIFS - Apple Support


You can add as many test-values, condition pairs within the function as you need.


SG


Reply

Sep 21, 2023 5:41 AM in response to SGIII

yes, the first 2 tables of totals show I cant seem to separate the 2 different microphone types


C/F are the colour codes for the microphones, F=beige and C=brown (just the way DPA do it)


from left to right on the bottom table which is what the

Barcode of microphone-make-colour code-current assignment-new/old/crackle etc

Reply

COUNTIF Question

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.