Hi
I am totalling up a column but some cells in the range will have error,
i need to total up the column and skip any cell that has an error e.g #VALUE! but continue caculating the rest.
I have attached a sheet as example.
Thanks
Hi
I am totalling up a column but some cells in the range will have error,
i need to total up the column and skip any cell that has an error e.g #VALUE! but continue caculating the rest.
I have attached a sheet as example.
Thanks
Here:
Formula:Please Login or Register to view this content.
confirm with ctrl+shift+enter (not just enter)
Last edited by zbor; 03-25-2014 at 06:22 AM.
Thank you its perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks