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

Hello,
Does anyone know about staragile or anyone have done courses in it. If yes, is it helpful?

like

How do people get on-site jobs while staying in India? I’m into business consulting-risk advisory-financial services & I have tried my heart out in applying everywhere (LinkedIn, indeed, company website) but no luck yet. It’s been my dream since when I was 8 to move abroad to gain global experience and earn decent money, I guess there’s no luck or a way for me. Trust me, I’ve tried everything since past 3 years, how do people get it?

like

If you could choose any organization in this space, which one would you want to work for and why?

like

Hi Fishes,

I am currently working as an Analyst in HCL Technologies BSERV which is considered as a BPO. I received a promotion to a new job post Sr. Associate-WPC. Is this new position also a part of BPO or does it come under IT or Technical Department? Also currently there is no hike being provided even though the band has changed from 0.3 to 1.1, can I expect a hike once the yearly cycle is completed?

like

Hi Fishes ,currently am in jpmorgan bangalore with 7yrs exp as pega developer getting 20lpa. Whats the market rate now if i switch.

like

It's annoying that most job postings that require you to have experience and proficiency in two languages always offer waaaaay less than the average salary for the level. 🙄

like

Anyone have an recs for self help books that help with work anxiety? I've felt so low on the totem pole since I joined in 2015 that I rarely give any opinions at the office. Obvi this is (cont'd)

like

Is it true that most top law firms will generally not consider CSK associates when hiring?

likehelpful

Can anyone please help me how much i should negotiate with HR at capegemeni at Pune current fixed CTC 13.5 at 5 years of experience in current organization.

Technology currently used- SCCM/MECM

likehelpful

Anyone here ever taken Focus Factor? I’m on Strattera but am considering a switch because the regular appointments and cost of medication really adds up. Am curious to know if anyone feels like Focus Factor helped.

like

Re: exit opportunities - which is better? Big law, highly specialized or boutique corporate firm where I do everything but “specialize” in m&a, VC and capital markets?

like

Is the future of web design headed to no code tools like Webflow?

likefunny

How is she 13 years old?!?

Post Photo
likeuplifting

i want pizza.

...and a new job.

likeuplifting

Python is a very popular programming language. But there aren't many python jobs in the market?

like

Cocomelons dad is dead behind the eyes

funnylike

How should I understand about the employment type ( contractual or permanent) from the offer letter of Deloitte india ?

I received an approval for H1B transfer but in my application it looks like they used the wrong I-94 number and last date of entry. I specifically provided the latest and correct one to them during preparation- anyone have any idea why they would do that? It seems like it would have been deliberate

like
uplifting

FTE vs Contracts. What are some of the pros and cons? Which one do you prefer and why? How and why it best meets your personal and professional goals?

like

Additional Posts in Excel Genius

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

Best pdf to excel converter?

like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

What are your top Excel ninja tricks? Ones that few people know...

like

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

What are the most typical models you all build

likehelpful

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

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

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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