Related Posts
Do you always need an MBA to get into MBB?
How do you all deal with protein farts?
Additional Posts in Consulting
Systems upgrade successful 💉
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.




Countifs let’s you add multiple conditions
Super easy to count values using a pivot table for the unique values. Put the fruit column in the row group and any column that has any value in all rows and you’ve got it.
Count
=COUNTIF? Doesn’t work bc there’s multiple variables
COUNTIF
I like to make a separate tab for indexes/ reference variables
Pro
CountIF (column:column, “Apples”)
Rising Star
Then have a column that lists the variable you’re looking to count, and a column that includes the number/formula.
A B
Apple =countif(
Banana =
Orange =
There’s your table on the side
Then use another formula, if needed (not sure I’m understanding correctly) that sums up B so you can say, apples/bananas/oranges are referenced a total of 10 times. Or whatever.
COUNTIFS
No judgement here. Just relief that I’m not an analyst.