Max, for charting it is actually better to have N/A, otherwise, if you put data labels into the chart, it will show zero when there is no column. With N/A the chart will be cleaner. Also, the N/A is a "natural" result of the formula if there is no value found for the criteria. Trying to error-trap it and exchange the N/A for a 0 would be a waaaay much longer formula. Like this:
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Bookmarks