Looking for formulas to get me individual cells in a range that are TRUE for formula

Hello,

I need a formula that can look at a range of cells and return when one of the cells either has a formula in it or does not? T/F


as you can see below using the ISFORMULA function works, except not really. Example, the two yellow cells are formulas, but the

Please Login or Register  to view this content.

range returns FALSE. Technically the range is not false because there are two formula cells. Then, I want to do the same thing for the row 4 below it, except this time return when there is data instead of formulas. Attached is excel sheet example.

Also, is there a way to catch when a cell is not summed in a range? Example, I am using

Please Login or Register  to view this content.

. I want a formula that will tell me which cell in a range does not have a SUM formula.

thanks


Capture.JPG

This formula will count how many cells in your range have a formula

Formula:

Please Login or Register  to view this content.

This will return TRUE/FALSE

Formula:

Please Login or Register  to view this content.

Not sure about your last request. So if, for example, if the cell H9 in the range B9:M9, does not contain a sum formula, you want your formula to return H9?
What if more than 1 cell does not contain a SUM? Does it matter if it's a formula or constant, just as long as it's not a SUM?

If one or more of your formulas are inconsistent with the others in the row, you will get the little green triangle. (Cell G9 in example) However, you won't get a green triangle if one of your cells doesn't contain a formula (Cell J9). I think you might need some VBA and a User Defined Function for this one.