Excel help need

[Trader]

In Excel.....I have a column of numbers and I want to count the number of entries.

Some of the numbers include letters (ie: 31, 31a, 32...)

In the next column, I have comments.

 

I'm trying to figure out a formula to say:

Count the number of entries of numbers and letters within the range in column 1 and MINUS the number of comment entries in column 2.

 

I get messed up because it is not all straight numbers. not all numbers have comments beside them.

 

Counting Empty cells will not fit my needs.

 

I'm going to need to do this and combine the totals for 4 ranges of cells.

any suggestions?

[Trader]

how many entries in column 1 minus those in column 2

repeat for range range 2, range 3 , range 4

 

I'm trying to duplicate a form....so only so many rows will fit on each "page"

The rows =the range

 

i.e. (Count(A4:A24))-(Count(B4:B24))

 

and do the same thing 4 different times for the different "pages" then give me the total.

 

because the cells contain numbers combined with text, the above formula won't work

[wes0778]

I think CountIf is the function that you are going to need......

[Trader]

Never thought of hidden cells....that will work just fine!

 

Thanks Don!

[Trader]

PM sent Don !