Count from left to right

  • Thread starter Thread starter Eva Shanley
  • Start date Start date
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...
 
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.
 
Back
Top