COUNTIF Question

Question

Level 1

8 points

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

Answer 1

Top-ranking reply

SGIII

Level 8

37,562 points

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

Answer 2

Ollie100 Author

Level 1

8 points

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

Answer 3

SGIII

Level 8

37,562 points

Sep 21, 2023 5:34 AM in response to Ollie100

Can we assume the first two tables in your screenshot are the "totals" tables? What does your data table look like? Is that the bottom table? What do C and F stand for?

SG

Reply

Answer 4

Ollie100 Author

Level 1

8 points

Sep 21, 2023 6:28 AM in response to SGIII

ill give it a go thank you

Reply