In excel how can I tell if cell is a number or formula 3

[ls62]

Hi,

I want to test a range of cells and sum all the cells that have a number in them, but not any cells that have formulas. For example I have a range of rows/columns with numbers and then subtotals for a month, more numbers and another subtotal

ex:
1:5
2:6
3:3
4:14 <subtotal formula
5:4
6:1
7:3
8:8 <subtotal formula

I want count rows with numbers (not formulas) and also sum. I would like to do this as a function or formula, not a macro.

Thanks for any help

LEE

 

[bandit600]

Lee

Count only counts numbers, so will ignore all the subtotals. The countif subtracts any non-subtotals that are 0.

Is that what you are after?

bandit600

 

[ls62]

Bandit600,

OH. Ok I see. I did get this resolved using the function that zathras gave us, but I'll try yours too! There's never enough ways to solve a problem. Never know when I might use it in the future.

Thanks.

LEE