Excel Help Needed - Pleeeeease

[glynners]

i have a spreadsheet along the lines of the one attached but a wee bit bigger. i need to know how to count the number of numbers in each column excluding the n/a's......

It also needs to total up the value of the rows, excluding the n/a's

would this be possible?

cheers :)

[Win2Win]

i have a spreadsheet .....
Good for you......



.....does that help? :D

[mathare]

i need to know how to count the number of numbers in each column excluding the n/a's......The number of numbers in column B is given by =Count(B:B). But using this formula in column B will create a circular reference so if you know the size of the array use that, e.g. =Count(B1:B256) would work if entered anywhere except in the range B1 to B256


It also needs to total up the value of the rows, excluding the n/a's=SUM(B2:Z2) gives you the total ofd all numeric values in cells B2 to Z2

[glynners]

Cheers keith :wink

:helper

[glynners]

Cheers Mathare :)