If total cell equals 0 add the text "N/A"

**Laurent53** · 07-23-2015, 10:51 AM

Hi Guys,

Hope you are doing well. I have basic knowledge in Excel because this request sounds easy. I am playing around with diff formulas but can't figure out this.

I would to calculate the total between a range of values (A2:A50) and want to add in the formula to display the text "N/A" in the cell (A51) if I don't have any values.

Would you please give me a hand with it?

Thanks for your help!

Laurent

**AlKey** · 07-23-2015, 10:54 AM

Try this

=IF(SUM(A2:A50)=0,"N/A",SUM(A2:A50))

**bhenlee** · 07-23-2015, 10:56 AM

try this formula in A51:

=IF(COUNTA(A2:A50)=0,"N/A",SUM(A2:A50))

**shg** · 07-23-2015, 10:56 AM

Another way:

=IFERROR(1/(1/SUM(A2:A50)), "N/A")

**Laurent53** · 07-23-2015, 11:11 AM

Thanks again to all of you for your help! It's awesome when it works!! And I definitely understand more! Thanks again!

If total cell equals 0 add the text "N/A"

LinkBack

Thread Tools

Rate This Thread

Display

If total cell equals 0 add the text "N/A"

Re: If total cell equals 0 add the text "N/A"

Re: If total cell equals 0 add the text "N/A"

Re: If total cell equals 0 add the text "N/A"

Re: If total cell equals 0 add the text "N/A"

Thread Information

Users Browsing this Thread

Similar Threads

Macro which searches for cell with text "Total Cost" and references cell 3 to the right

Insert Row on Different Tab if value in cell equals "Text"

[SOLVED] Insert Row if cell value equals "Text"

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

[SOLVED] Delete row if cell in Column N equal "Different" or Column P equals "Blank"

Excel 2007 : Function where results cell equals partial "text" of reference cell??? HELP!!!

[SOLVED] Macro to delete entire row if cell contains the word "total" or "Total"

Total IF Value equals "Yes" ?

Bookmarks

Bookmarks

Posting Permissions