Hi experts
I have the below code to count values in my given range, however, I want to have the cell returns as blank if the cell value is zero
Thanks in advance!![]()
Please Login or Register to view this content.
Hi experts
I have the below code to count values in my given range, however, I want to have the cell returns as blank if the cell value is zero
Thanks in advance!![]()
Please Login or Register to view this content.
Hello purin0c0,
You need to use an If ... Then statement to either display the sum or a blank.
![]()
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
thanks, works great!
Hello purin0c0,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks