(Brand new analyst don’t judge) What is the excel function for when you want a count of the total number of times something is mentioned (e.g,. apples, oranges, carrots) in a new table? E.g. apples stated 4 times, oranges 3, etc.

like
Posting as :
works at
You are currently posting as works at

Countifs let’s you add multiple conditions

likehelpful

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.

like

Count

=COUNTIF? Doesn’t work bc there’s multiple variables

COUNTIF

I like to make a separate tab for indexes/ reference variables

CountIF (column:column, “Apples”)

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.

helpful

COUNTIFS

No judgement here. Just relief that I’m not an analyst.

Related Posts

My BGV is in progress for JPMC. I got mail to upload experience/relieving letter. I still didn’t get the relieving letter from my previous company. Shall I upload resignation acceptance letter for this?

like

Anyone start there career at GE as an FMP? Deciding if I should go get my MBA or if the program holds weight. Feeling like I got conned while in college

like

Anyone working for AMAT account under BIBA ?
My role is data science and iot engineer. What questions can I expect in an internal interview ?

Does Amex renegotiate offer based on counter offer after accepting the offer letter?
My joining is in Aug 1st week.

like

I’m considering straightening my teeth. What are your experiences with Invisalign vs. Smile Direct vs. other options? Any big differentiators?

like

Masters only patent agent in life sciences, worked in house for 2 years as a paralegal, patent agent for one year now. What should I expect for salary in NYC boutique/big law ?

What books would you recommend for someone wanting to get better at sales?

like

What should be the designation for 11+ exp in Oracle India?

like

Hi all! I’ve been dating my bf for about 4 months now and there are some things he says/is into that make me believe he is either Bisexual or has gender dysphoria. I could really use someone’s advice who has a similar experience like this. Is anyone willing to chat? I just want to be supportive and helpful.

like

what are the potential start dates for EH associates at BCG?

like

Do you always need an MBA to get into MBB?

likefunny

Do you gotta work on last working week ay ey gds? Just wondering.

likefunny

Educational book recommendations! I love to read, please list any educational books you loved, especially related to special education!

like

Pineapple burn and passion fruit pump by ghost. Thank me later

like

How do you all deal with protein farts?

funny

11/24 check-in: Happy Thanksgiving to all who celebrate! What are everyone’s workout plans for today?

Post Photo
funnylikeuplifting

How important are “assigned” courses to complete ? Any issues if I do them after the due date ? Or are they as important as “required”learning .

like

Random partner asked a litigation-related question to a partner I frequently work with (i’m a transactional associate). My partner cc’d me and said for me to briefly look. Asked the library. They got me a great case. Sent it back. Now the random partner is asking for more cases in another circuit.

I haven’t done caselaw research since 1L and this isn’t even my practice… wtf do I do (I am fully utilized in my normal work and have a few deals closing soon…)

like

*In biweekly team sync meeting*
“Oh fuck this, I’m gonna kill myself”

“Oh goddammit, I’m not on mute”

likefunnysmart

I work at an agency and I'm about to be promoted from senior to lead designer. What do you think would be a fair % of salary raise?

like

Additional Posts in Consulting

Male fishes - looking for skin care recommendation. What has worked for you?

like

Was interviewing with a hiring manager whose team happened to be all-male. When I asked what a candidate could do to be successful in the role, he started the sentence with "He would need to..." 🤦🏻‍♀️

funnylikehelpful

Is a lot of consulting just taking notes on meetings? I’m not a fan of this.

funnylike

I'm trying to buy a bigger than normal whiteboard for my home office: any recommendations?

like

Looking to improve general communication skills (especially around structuring narrative/ key messages), any books/courses that you would recommend?

like

Whats the difference between a Partner and Leader at EY?

likefunny

Just fired my therapist. Feels better than it should

like

I make $4000/M after taxes and max 401K and spend about $2400 for all fixed costs (rent, utilities, etc). With roughly $1600 left, and with a strong goal of saving as much as I can, what are some recommendations on how I should allocate my money better. I know this is vague but need some better financial planning.

like

LinkedIn featured section - I’m 3 years out of school and want to update this section. As of now, I have an old article from 6 years ago about something I did back in college. Any suggestions on how to get someone to write an article on a early career consultant? Would just throw that up on my featured section

Open to other suggestions of stuff to put on featured section, would love to crowdsource ideas for inspo

like

Do I need to get winter tires in Dallas? Moving there later this fall.

funny

Resume writing tip: how to make “conducted client workshops to communicate and gain agreement on recommendations” sound more impactful?

likesmart

Men, what’s a good work winter coat/jacket/parka company? Looking to stay under $500.

like

Facebook (Meta) Hi. What do you think is the highest paying role/job and at what company for a 3 YOE project manager? Is more than 100k crazy? Facebook Netflix

like

Any good book recommendations for new Managers in consulting ?

like

Stupid question: do you get to alt-travel? Not fly home to your home office on the weekends, but use that budget to fly somewhere else?

like

Anyone have any recommendations for HR certificates that are worthwhile?

A friend who’s degree is in polisci is trying to move into the hr space, either in L&D or culture/employee engagement. Initially was hoping to use transferable skills to get a job in that field - but all the descriptions ask about HR experience and not as much seems to be biting.

like

Systems upgrade successful 💉

like

Any tips for getting more discounted one way car rentals? Using my EY code usually gives me awesome rates but I’m booking a drive down the PCH in california and the rates are insane! TIA :)

like

Anyone here from Strategy&? What are your thoughts about the company? WLB, Salary, Projects, etc.? How it compares with Accenture S&C and Big4 Consulting?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal