Count but Also Ignore

[Steve 1962]

Hi

I have a formula that works fine but is counting cells with no value but contains a formula. How do I modify the following formula to not count cells with formulas if the result is a blank -

=COUNTIFS(TABLE1,”<=“&EOMONTH($BE4,0),TABLE1,”>=“&DATE(YEAR($BE4),MONTH($BE4),1))

Thanks

 

[Peter_SSs]

The formula posted contains incorrect quote marks. They are ” when they should be " However, that shouldn't cause what you are describing.

With the correct quote marks the formula for me is not counting cells you are describing. I guess that means my data and yours are not the same. Can you post a small sample of yours using XL2BB? Make sure that your sample includes the formula in TABLE1 that is producing the blanks as well as cell BE4. You can hide intermediate columns if TABLE1 and column BE are distant from each other.

 

[Steve 1962]

The formula posted contains incorrect quote marks. They are ” when they should be " However, that shouldn't cause what you are describing.

With the correct quote marks the formula for me is not counting cells you are describing. I guess that means my data and yours are not the same. Can you post a small sample of yours using XL2BB? Make sure that your sample includes the formula in TABLE1 that is producing the blanks as well as cell BE4. You can hide intermediate columns if TABLE1 and column BE are distant from each other.

OK - thanks Peter. I’m keen to get this resolved but unfortunately I won’t be able to reply to you for several days. The computer I have is a work computer and won’t let me download XL2BB. As soon as I return back home, I’ll send a detailed reply from my own computer.

Thanks

 

[Peter_SSs]

OK, no problem.