Ignore Blank Cell

Shannon Lacerda

How do I fix the formula below to ignore the blank (Date) cells. The second image is where the formula is linked to.

Paul Newcome

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)

BullandKhmer

=IF(ISBLANK(REFERENCE CELL),"",FORMULA)

Shannon Lacerda

@BullandKhmer

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)

Paul Newcome

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)

Shannon Lacerda

@Paul Newcome

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)

Paul Newcome

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)

Shannon Lacerda

@Paul Newcome

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.

Paul Newcome

Happy to help. 👍️