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?

[XV1100SE]

Okay..... I'm up to the challenge.

Post your file that you want to work with.

Need a little more explanation on what you are trying to do.

If I understand correctly... you want to know how many cells in column 1 have an entry in it (not NULL - value X), how many cells in column 2 have an entry in it (again, not NULL- value Y), and subtract Y from X.

This part confuses me - "combine the totals for 4 ranges of cells"

[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......

[XV1100SE]

=IF(A2="",0,1)

 

This results in... if A2 is NULL, true result is 0, if false result is 1

 

See sample spread sheet and if I'm off base with what you are trying to do, let me know.

 

What you could do is insert columns C and D and then hide them, putting your results in a cell that isn't hidden.

[Trader]

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

 

Thanks Don!

[Trader]

PM sent Don !