Can you use the SUBTOTAL feature with formulas as well? Such as IF statements

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

Yes, with conditional =SUMPRODUCT

Refer to the link below for more details: https://exceljet.net/formula/count-visible-rows-only-with-criteria

likesmart

Not sure your end goal but check out AGGREGATE.

like

Related Posts

In your experience, would my current job (SMB, Sales role, CPA networking) be a benefit if I transitioned into this industry?

like

Thoughts on best (preferably free) credit cards? Thinking of opening another. I've only ever had these:

- Uber (used to be 4% cash back on dining; they've since updated this to 5% uber cash. I never use uber so I let this card expire)
- SavorOne from Capital One (unlimited 3% cash back dining & entertainment; 2% groceries)

I mainly spend on dining, groceries, gas, and online purchases (amazon, target). Maybe travel when things calm down but not right now.

like

INTERN: Can you voice for me?
CW: Sure... but this script is for a sale that ended last weekend?
INTERN: Yeah I was slammed last week, I’m only getting to it now.

funnylike

Hello fishes,

What is the maximum package one can expect for Customer Support Senior Associate with 4 years experience overall?

Do you have to know some within AmerisourceBergen to work for them? I feel like I have tried 5 times to work for them and nothing has happened.

like

Does anyone work for SaltPay? Currently or previously?

like

Had a steamy dream about my manager last night and now I can't look at him the same.

funnylikeuplifting

Does anyone else have to do progress monitoring? This is bull!

like

Any tips on helping my remote bond/feel more connected with each other?

like

What pays better? Software development vs IT consulting.

like

My eyesight is getting worse and it’s lowkey stressing me out lol. On that note, do you know what the cheapest way to get contact lenses is?!

like

Hello 🐠

Are your firms transitioning to golden visas? If yes, at what level? Please answer with firm - level. Thanks!

like

Hi, I have an interview at EY and I wanted to know what kind of questions can I expect in the 2 rounds following the screening call ? I was told the 2nd round will be with a panel of three people and if I move on to the next round then the 3rd will be a team based interview. I could really use some help.

like

Sucks when you have a bye week :(

like

Day shift or night shift and why?! :)

like

What’s everyone making as a product manager in Telecommunications?

How long is long enough to stay at 1 job/position?
Start to feel that I’m coasting, and I hate it. My motto has always been ‘move up or move out’ but lately I’m less and less motivated. Is anyone on the same boat? Discussed with my boss a few times; don’t think I could move up at this place anymore. Need a slap (or a few) to move my b*tt

like

Back online after 4 weeks in the hole after being apprehended by the FB po-po because of some snitches. Whaddy I miss? #snitchesgetstitches

like

Cheers to everyone celebrating promotion at the airport bar before getting home!!

like

If I put in 2 weeks today so that my last day is early Nov. However, what if I’m told to leave immediately, then does that mean I would lose my benefits at the end of this month? How do i avoid this?

like

Additional Posts in Excel Genius

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

like

I run a chatbot that collects students inquiries and want to spot reoccurring questions without going through all 4,000 questions. So far, I’ve created an advanced find keyword indicator to help bucket questions into themes, however I want to build an FAQ sheet. All/any help appreciated 😅

like

What are your favorite excel macros to make you more efficient at work?

like

Looking to expand my Excel skills by learning Power Query/Power Pivot & VBA & then expand my learning towards certain programming languages (not Excel related).

I currently have access to LinkedIn Learning, but curious about Udemy and Coursera. I know about the differences between them, but content-wise, anyone have a better experience with one over the other out of three? Other recommendations?

likehelpful

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
like

What is the most useful macro for my tax accounting professionals?

like

To see a list of all tabs you right click on the arrows to the left of the tabs. Is there a shortcut to this without a mouse?

like

What is one excel command that is faster if you use a mouse?

likefunny

My company upgraded to the latest Excel and want to take advantage of the new functions. I have a sheet with several nested INDEX-MATCH’s. I spent some time upgrading them to the new XLOOKUP, but after doing it seems like the sheet runs a bit slow (I have like 20k rows of lookups that seemed to work okay the old way). I’m doing the usual things to make it work faster - not selecting the whole column, using smaller lookup ranges etc. Anyone notices similar slowness with XLOOKUP?

like

Is there a way to add trend lines/fitted lines for each category on a bar chart? Looking for something similar to below.

Post Photo
like

Wait … xlookup is basically VLookup and Index/Match?

Is this seriously a viable alternative because what the hell have I been doing with my life?

likefunnysmart

Anyone ever dealt with grouped rows / columns inexplicably stopping working? I have a big and pretty important model which uses grouped rows a lot (to click the plus and pop out more detail), and yesterday I opened it and it’s just all hidden instead of grouped. Any ideas how to fix?

like

Would you rather use Excel versus CRM to store data and manage records? If so, why?

like

Google Sheets vs Excel - pros and cons? Asking seriously.

like

How would I create a bar graph that shows same store sales growth for 5 products that were promoted during different time periods?

like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

Looking to use an XIRR formula with an “As of” date option (as of 12/31, 9/30, etc…) So it would essentially stop pulling dates and values once it hits the date in the “as of” date cell.

Any ideas? Much appreciated.

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

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