Ignore Blank Cell
How do I fix the formula below to ignore the blank (Date) cells. The second image is where the formula is linked to.
Best Answer
-
Sorry. Just realized I forgot to remove one of the closing parenthesis. Try this one.
=SUMIFS({2021 Bid Log Value}, {2021 Bid Log Range Status}, "Won", {2021 Bid Log Range Rank}, "B", {2021 Bid Log Month}, IFERROR(MONTH(@cell), 0) = Month@row)
Answers
-
=IF(ISBLANK(REFERENCE CELL),"",FORMULA)
-
What am I doing wrong, I get an error #incorrectargument. I tried the *IF part in the middle as well and does not work?
=IF(ISBLANK({2021 Bid Log Range Rank}), "", SUMIFS({2021 Bid Log Value}, {2021 Bid Log Range Status}, "Won", {2021 Bid Log Range Rank}, "B"), {2021 Bid Log Month}, MONTH(@cell) = Month@row)
-
Try this...
SUMIFS({2021 Bid Log Value}, {2021 Bid Log Range Status}, "Won", {2021 Bid Log Range Rank}, "B"), {2021 Bid Log Month}, IFERROR(MONTH(@cell), 0) = Month@row)
-
I get #Unparaseable error for the below
=SUMIFS({2021 Bid Log Value}, {2021 Bid Log Range Status}, "Won", {2021 Bid Log Range Rank}, "B"), {2021 Bid Log Month}, IFERROR(MONTH(@cell), 0) = Month@row)
I did realize in though I was referencing the wrong cell in the below formula, I corrected it and get the same error #Unparaseable
=SUMIFS({2021 Bid Log Value}, {2021 Bid Log Range Status}, "Won", {2021 Bid Log Range Rank}, "B"), IF(ISBLANK({2021 Bid Log Month}, "", MONTH(@cell) = Month@row)
-
Sorry. Just realized I forgot to remove one of the closing parenthesis. Try this one.
=SUMIFS({2021 Bid Log Value}, {2021 Bid Log Range Status}, "Won", {2021 Bid Log Range Rank}, "B", {2021 Bid Log Month}, IFERROR(MONTH(@cell), 0) = Month@row)
-
OMG that worked, thank you. Now I need to do the same thing to a few other formulas that I am having the same issue.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!