If = 0, return a Blank or ""

lisalettieri

I'm using the below to count different types of calls we receive, by person, by month. If a person gets none of those calls in Jan for instance I want it to return a blank, not zero. I tried IFERROR as below but that did not work. Thanks!

=COUNTIFS({2025 Call/Email Log Recipient}, ="Bob Flowers", {2025 Call/Email Log Contact Type}, ="client call", {2025 Call/Email Log Date}, >=DATE(2025, 11, 1), {2025 Call/Email Log Date}, <=DATE(2025, 11, 30)) works but returns 0's if nothing meets the criteria. we want blank cell.

=COUNTIFS(IFERROR({2025 Call/Email Log Recipient}, ="Bob Flowers", {2025 Call/Email Log Contact Type}, ="client call", {2025 Call/Email Log Date}, >=DATE(2025, 11, 1), {2025 Call/Email Log Date}, <=DATE(2025, 11, 30), ), "") returns unparseable

Melissa Yamada

Hello @lisalettieri

Using IFERROR will not work since value "0" is not considered as error message.

Try this:

=IF(COUNTIFS({2025 Call/Email Log Recipient}, ="Bob Flowers", {2025 Call/Email Log Contact Type}, ="client call", {2025 Call/Email Log Date}, >=DATE(2025, 11, 1), {2025 Call/Email Log Date}, <=DATE(2025, 11, 30)) = 0, "", COUNTIFS({2025 Call/Email Log Recipient}, ="Bob Flowers", {2025 Call/Email Log Contact Type}, ="client call", {2025 Call/Email Log Date}, >=DATE(2025, 11, 1), {2025 Call/Email Log Date}, <=DATE(2025, 11, 30)))