Making a field active

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wait3264 - 31 Jul 2006 12:23 GMT

I am trying to set up a spreadsheet to calculate tips for wait staff. There
is no cash involved and all tips are paid through the server's paycheck.I
would like the spreadsheet to contain all the names of the staff and be able
to designate which ones worked that particular shift for the tip share. For
example, there are 10 waitresses who work at the establishment but only 5
work on any given day. I am given a total amount of tips for the day which is
divided equally among those who worked that shift. Right now the work is done
manually and is sometimes time consuming. Thanks, Kay

Reply to this Message

Don Guillett - 31 Jul 2006 13:07 GMT

pershaps a helper column with a x in it and then use countif or sumif.

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I am trying to set up a spreadsheet to calculate tips for wait staff. There
> is no cash involved and all tips are paid through the server's paycheck.I
[quoted text clipped - 8 lines]
> done
> manually and is sometimes time consuming. Thanks, Kay

Reply to this Message

wait3264 - 31 Jul 2006 16:43 GMT

> pershaps a helper column with a x in it and then use countif or sumif.

Reply to this Message

wait3264 - 31 Jul 2006 16:57 GMT

I looked it up and I think the sumif will work. I need to figure out a way to
add in bus people and expeditors who get a half share and quarter share. Can
I use the x field as you suggested and have it add a different column?
Thanks, Kay

> pershaps a helper column with a x in it and then use countif or sumif.
>
[quoted text clipped - 10 lines]
> > done
> > manually and is sometimes time consuming. Thanks, Kay

Reply to this Message

Rate this thread: