Forum Discussion
Solved
Using a Count formula but excluding cells containing a formula
I've been asked to figure out a small problem at work with some Excel sheets for my coworker. Essentially, I'm looking at Column H that spans from H4 to H428. They're broken up into sections that don...
=SUMPRODUCT((NOT(ISFORMULA(H4:H26)))*(H4:H26<>""))You can try SUMPRODUCT to count the cells without a formula and excluding blank cells.
=SUMPRODUCT((NOT(ISFORMULA(H4:H26)))*(H4:H26<>""))You can try SUMPRODUCT to count the cells without a formula and excluding blank cells.
Okay great it looks like this one worked, thank you. Could you explain why exactly this worked though? Maybe a breakdown of the parts of the formula? I have pretty baseline knowledge of Excel and haven't explored much with formulas yet. edit: I think I understand the first half of the formula. The first half is stating that it's going to count the cells that don't contain a formula, but what does that second half mean? I know that H4:H428 would be my range, but what does the <>"" mean?