Filter Help

**Garlo** · 05-11-2021, 08:34 PM

I want to make a filter (or use a better function if told so) so that I can get a value that looks for '0's in a column, and then uses the corresponding value to that '0' or '0's and sums them together. I have done this and it all works fine, however when there are no '0's found in the column it comes up with '#CALC!', I understand that this is because there are no '0's, but I want to know if I can get it to give me a value of '0' if there are no '0's found in the column whilst still doing the previous functions works?

See attached below for what the section of the sheet looks like when the function is working when there are '0's found in the column 'E'
Capture.PNG

See attached below for what the section of the sheet looks like when the function is not working when there are no '0's found in the column 'E'
1Capture.PNG

Ideally, I want it to run as is, but when there are no '0's found in column 'E', I want the cell above 'Completed' to show the value 1, and the cell above 'Remaining' to show the value 0.

Thanks in advance.

**Gregb11** · 05-11-2021, 09:02 PM

1. Your profile says Version 2104. I'm assuming you are on MS365 if you're using FILTER. Please update your profile.
2. You should attach a sample file. Please read the yellow banner at the top of the page.
3. Without looking into too much (without a file available), maybe wrap your formula in IFERROR and have 0 as the result if error?