Count from left to right

E

Eva Shanley

I need to find a way to prompt a user when they've keyed
98 entries in a spreadsheet. Entries can be keyed in up
to 3 columns per row which would equal 3 entries in the
count; so, a row could count for 1, 2, or 3 entries. I
think I can do this with a macro, but wondered if there
was a way to use the Count function to count left to
right. I'm assuming Count would look at all the entries
in Col. A first, then move right to the other 2? Thanks
as always...
 
P

Paul

Eva Shanley said:
I need to find a way to prompt a user when they've keyed
98 entries in a spreadsheet. Entries can be keyed in up
to 3 columns per row which would equal 3 entries in the
count; so, a row could count for 1, 2, or 3 entries. I
think I can do this with a macro, but wondered if there
was a way to use the Count function to count left to
right. I'm assuming Count would look at all the entries
in Col. A first, then move right to the other 2? Thanks
as always...
Click to expand...

I'm not sure exactly what you want (when counting, it doesn't matter what
order you use!), but
=COUNTA($A:$C)
will tell you how many cells anywhere in columns A to C have entries in
them.
 
A

Anders S

Eva,

You can try Data>Validation with a formula like
=COUNTA(A:C)<98

HTH
Anders Silven
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count with two criteria in a second worksheet 1
How can I count deviations between two rows? 3
Count IF Function 7
Help with a formula 3
counting entries 4
I am using the COUNT function to determine the 1
complex sort search and replace macro 2
countif function 8

Top