I need a formula that will look in certain named cells and count how many entries are in those cells.
For example, in one cell I might have this formula:
=4+16+12+24
Which results in the cell displaying the total "56".
In another cell I have this formula:
=5+20+7
Which results in that cell displaying the total "32".
In this case, such a formula would be directed to look at those two cells and count how many entries exist, returning the answer, in this case, "7". That is, 4 entries in the first cell plus 3 entries in the second cell = 7 entries.
Does anyone know what the formula would be to do this?
Bookmarks