Hi I need help please! Trying to sumifs with one of the criteria being a blank cell. Problem is the cell is not truly blank as it contains a formula that is producing the blank cell. How can I get around this to get my proper summed results???

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

How about change the formula that returns the blank to return something else (e.g the word “blank”) and run the sumif based on that?

like

Criteria = "", or whatever the formula is outputting

like

I tried this and it’s not returning a value because the cell is not truly blank due to the formula sitting it

Instead of blank, have the formula spit out one space, so “ “. Sumif on that.

like

Plz never use " " if "" isn't working. It will f* up so many things later on (e.g. the excel cells being empty without being empty error, replacement errors etc.)
If the blank cell is created by a SUM, it seems you have set zeros to not to be shown. Still the value of the cell is 0. So just add that as criteria.

like

How about nesting ISBLANK in your formula?

like

Agree with Bain1, have it spit out a value, maybe 0, then use Conditional Formatting to make 0s have white font. Then use 0 as your criteria in the sumifs!

Related Posts

I don't understand why so many people expect kids not to learn manners. I'm not saying that they have to be experts on etiquette, but we need to have higher standards for them

like

We’re looking to implement incentives to encourage community engagement. We’re going to test both material incentives (product) and good ol’ fashion recognition. Which one do you think will do better?

like

Happy and proud to be one of Donald Trump's people as well! Bless him, bless us all, and may God bless the United States!

like

What is the work from home scene in HSBC Bangalore?

like

Do you think all adhd-ers work better from home? Since transitioning out of the office completely it's been so much easier for me to schedule things around my energy levels rather than try to turn it on for work and off when I get home. Anybody else feel this way or do you love working in the office?

like

1 year, 3 months and 22 days later, I’m employed👌. Easiest year of my life.

likeuplifting

My confession is that I have seen the medical field change so much over the past 20 years, that it's unrecognizable in both good and bad ways. More people are leaving than staying, and I am worried the quality of care is dwindling. I try not to burden friends and family with some of the things I've seen recently, but the short version is that I'm no longer sure I have faith or trust in it myself.

like

What is the current work schedule in T systems.

I heard WFO has started ?

Can anybody confirm who is currently working. I have my DOJ in 10 days.

Hi All! Here looking for work in Healthcare Operations/Project Management. Open to FT physical position in South Florida, as well as hybrid or remote positions within the US. Looking forward to networking.

like

Thoughts on the strengths of different ad schools’ copywriting tracks? I’m leaning toward applying to Denver Ad School, but it seems like it isn’t a Fishbowl favorite, despite their students’ books and the jobs they receive.

like

What would be the best way to lose fat on my legs?

Just weight train everything and my legs will lose fat? Or can I do something more specific?

like

How many bros here are in/ever tried/are considering therapy? What’s your experience been like?

like

A lot of people in public end up in relationships together, why not jumpstart the process? Post your sex, age, interests, and city. PM each other if interested.

like

Hi I got offer from AU small finance bank tech team wanted to know if they provide wfh to their tech team.

Is it a worth to join??

like

Hi everyone! 🎉

I’ll be moving to the Bay Area soon, and I’m wondering if anyone has any recommendations of areas to live? I’m thinking San Leandro or maybe Walnut Creek? Palo Alto?

I am looking for a 2 bedroom apartment that’s not over $3000/month! If someone is subletting a furnished place, that would be even better!

Thanks for your help! 💕

like

Who is Chevy's target audience.. at this point, I see more pickup truck commercials than anything.

like

Anyone dealt with age discrimination at work or thought they were fired because of it? I have a strong hunch I was let go because I'm older than most of the team and they're trying to get a "fresh perspective." To me it just sounds like they're firing anyone over 50.

like

At this point in the game it doesn't make a difference where you at everybody is getting laid off at one point or another the only thing I say is try to repair yourself for it if it happens to you

like

Additional Posts in Excel Genius

Anyone else ever need to explain a keyboard shortcut and realize you can’t remember what keys you actually use unless you manually go through the motions of the shortcut?

likefunny

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

like

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

like

I am trying to paste a table from excel to PowerPoint. When I paste it while selecting “keep source formatting”, everything changes significantly. Pasting as an image isn’t an option and I would rather not embed. What is the problem here?

like

Hoping someone here can help. I have two excel files, each with multiple worksheets, because they have different audiences. Management wants me to combine into a single workbook. Is there some way to restrict who can see which worksheet in this new file? Every user will fall into one of two groups. Alternative suggestions welcome!

like

What’s everyone’s favorite keyboard? Thinking about switching mine up

Hotkey question. Let's say I have 10 rows of data. Added a new column, want to quick fill cells. When I use Ctrl+ down, it select 10k rows because they are all blank. Any better option??

likefunny

I have a pivot table which has summed the number of minutes a task has been completed. I want to transform that to hours. I have tried to do =pivotminutes/60 and it works, but I can’t drag and apply the formula to all rows since it’s pivot data. It shows up blank. What am I missing?

like

Has anyone ever had issues with formulas not automatically updating when working in an excel workbook on sharepoint? Ive confirmed that the formulas are set to calculate automatically. I have to manually go in an click “calculate now” every time I change something, but it only updates in my view of the worksheet.

like

Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

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

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

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

What are the best Excel plug-ins for financial modeling? I used to use Training The Street or Boost but looks like neither are supported anymore. What do bankers use these days?

likesmarthelpful

Does anyone use XLOOKUP over Index Match? Why /why not?

like

Q. Is it possible to turn off track changes on a shared excel document ? I looked it up and it saying, “Press review” and I can disable from “Track Changes.” However on the document I’m using, I press review and I only have the option to “show changes.” Anyone know a way around this. Trying to at least remove the history due to a micromanaging manager

like

Boss seems to think I should learn Access and wants me to find a class. I can fumble around in VBA, but really only through using google. Is Access worth it or is there something better?

like

What is the What-If Analysis in Excel? Is it important for me to know?

like

In a pivot table I have a bunch of columns in the value field for different months. Adding them to value automatically populates as sum. I need to change to average, is there an easy way to do all of them at the same time? That would save me time on instead of 1 by 1

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