What is the formula to count a range of cells in a column that also contains formulas? Some cells will contain values that I want to count, but those only; not all cells.
What is the formula to count a range of cells in a column that also contains formulas? Some cells will contain values that I want to count, but those only; not all cells.
Hi robinc,
If you had a range in Column B from row 1 to 30 and wanted to count how many were formulas, try this:
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
That definitely worked, but I only want the sum of the results of the formula. If the formula returns a 0 (zero) I do not want to count it. Only the sum of the results if greater than zero.
Hi robinc,
This will do what you want.
Please Login or Register to view this content.
Cell values that are zero won't affect the sum, right?I only want the sum of the results of the formula. If the formula returns a 0 (zero) I do not want to count it.
Entia non sunt multiplicanda sine necessitate
Thread moved to correct forum section.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
This worked perfectly. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks