I'm adding these Cells together but if all the cells = 0 it gives me #Value!
How can I have it just leave blank if all cells = 0
Formula
=G9+J9+M9+P9+S9+V9+Y9+AB9+AE9+AH9+AK9+AN9
what can I add to that formula
Thanks for the help
I'm adding these Cells together but if all the cells = 0 it gives me #Value!
How can I have it just leave blank if all cells = 0
Formula
=G9+J9+M9+P9+S9+V9+Y9+AB9+AE9+AH9+AK9+AN9
what can I add to that formula
Thanks for the help
Last edited by AliGW; 07-31-2019 at 01:17 AM. Reason: Solved tag added - no need to edit thread title or add solved to post. Thanks.
you could probably do it like this...
=iferror(G9+J9+M9+P9+S9+V9+Y9+AB9+AE9+AH9+AK9+AN9,"")
However, I have a feeling there is a better way to do this. Do all of the columns in you calc have the same/similar headings?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That works perfect thanks
and they all have different headings.
Do the headings have anything at all in common?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks