SUMIF - If there is no value to return, return "NO DATA TO DISPLAY"

**Ben1985** · 12-01-2013, 05:30 PM

Hi,

I'm using the formula =SUMIF(Table1[Date],G251,LISTINGS!D:D) to return a figure from another sheet, this works fine. However, when there is no data to return is simple shows a 0. What would I add to my formula to say - if no value show text "No Data to Display"?

Hope this makes sense and thanks in advance.

Ben

**Tony Valko** · 12-01-2013, 05:34 PM

Here's one way...

=IFERROR(1/(1/SUMIF(Table1[Date],G251,LISTINGS!D:D)),"No Data To Display")

**Ben1985** · 12-01-2013, 05:38 PM

Perfect, thanks Tony.

Ben

**Tony Valko** · 12-01-2013, 05:40 PM

You're welcome. Thanks for the feedback!

SUMIF - If there is no value to return, return "NO DATA TO DISPLAY"

LinkBack

Thread Tools

Rate This Thread

Display

SUMIF - If there is no value to return, return "NO DATA TO DISPLAY"

Re: SUMIF - If there is no value to return, return "NO DATA TO DISPLAY"

Re: SUMIF - If there is no value to return, return "NO DATA TO DISPLAY"

Re: SUMIF - If there is no value to return, return "NO DATA TO DISPLAY"

Thread Information

Users Browsing this Thread

Similar Threads

How to check if a range of cells contains the word "unresponsive" and return "yes" or "no"

[SOLVED] Find "X" in range of cells and return various values based on the column "X" is found in.

Return "green", "yellow" or "red" from date/age and priority ranking

[SOLVED] Find multiple "text" criteria and return as ""Yes" in Matrix

Excel 2007 : Match Values and Return "Present" "Absent" "Per Diem" or remain blank

Bookmarks

Bookmarks

Posting Permissions