Count formulae

BGuest

Hi all,

Need a bit of help with constructing a formulae to input into a sheet summary box for the below situations:

• To calculate the count of 'Medical Device Related' category from the 'Relevant System' column
• Same as the above but for 'Non-Medical Related' category

I want to have a breakdown of the sub-categories for each of the above categories which have a summary sheet cell, so for example ' Number of 'Medical Device Related' with 'approved' status (Status column).

• To calculate of the 'Medical Device Related' category, how many have a status of 'Approved' etc (I would apply this formula to all categories).

All this information is to feed widgets in a dashboard.

I have tried CountIF/ but it is unparsable.

Please see the attached screenshot - this data is all dummy data.

Nick Korna

Hi @BGuest,

You do indeed want to use COUNTIF/COUNTIFS here.

In your first question:

For medical device related:

=COUNTIF([Relevant System]:[Relevant System], "Medical Device Related")

For non-medical device related, you would simply change the text within the quotation marks.

For the second part where you want several criteria, you use COUNTIFS instead. In your example of "Medical Device Related" in Relevant System & "Approved" in Status:

=COUNTIFS([Relevant System]:[Relevant System], "Medical Device Related", Status:Status, "Approved")

Hope this helps, but if you've any problems/questions then let us know.