I have several worksheets with employees ID numbers and expenses. They can
be reimbursed ½ of what they have spent up to a total of $400 on each tab.
They have a maximum of $1000 to be reimbursed for across all tabs. They might
not have expenses in each category (tab).
Is there a formula that could calculate for me which employees have reached
their maximum and which employees have not?

How is your workbook set up?
Is it a sheet per employee/category/tab?
How many tabs?
Try to describe it a bit more please. The answer will be quite simple but
with so many unanswered points it is hard to help you.


"jbelles" wrote:

I have several worksheets with employees ID numbers and expenses. They can
be reimbursed ½ of what they have spent up to a total of $400 on each tab.
They have a maximum of $1000 to be reimbursed for across all tabs. They might
not have expenses in each category (tab).
Is there a formula that could calculate for me which employees have reached
their maximum and which employees have not?

The workbook is set up per category with 6 tabs
Each category also has sub-categories listed in column c. The expenses from
sub-categories can be combined within the category to make up the total
allowed.
Right now I use a sumif on each tab (ID number is in column I and expense
for each line item in column V) to give me the total for each person per
category.
=SUMIF($I$12:$I$102,I12,$V$12:$V$102)
Thank you... I am not very good at describing.


"Arceedee" wrote:

How is your workbook set up?
Is it a sheet per employee/category/tab?
How many tabs?
Try to describe it a bit more please. The answer will be quite simple but
with so many unanswered points it is hard to help you.


"jbelles" wrote:

I have several worksheets with employees ID numbers and expenses. They can
be reimbursed ½ of what they have spent up to a total of $400 on each tab.
They have a maximum of $1000 to be reimbursed for across all tabs. They might
not have expenses in each category (tab).
Is there a formula that could calculate for me which employees have reached
their maximum and which employees have not?

I'm better at design rather than formulae and to me it looks like you may
need to revisit your project.
The introduction of sub categories really doesn't help me. You need to be
absolutely clear as to what data you have, how it is presented and what you
need to achieve.
I've not given up.
How about saving your s/s into Google docs and making it available so we can
see how far you have got . It'll be much easier than trying to explain.
Nil desperandum or whatever!

"jbelles" wrote:

The workbook is set up per category with 6 tabs
Each category also has sub-categories listed in column c. The expenses from
sub-categories can be combined within the category to make up the total
allowed.
Right now I use a sumif on each tab (ID number is in column I and expense
for each line item in column V) to give me the total for each person per
category.
=SUMIF($I$12:$I$102,I12,$V$12:$V$102)
Thank you... I am not very good at describing.


"Arceedee" wrote:

How is your workbook set up?
Is it a sheet per employee/category/tab?
How many tabs?
Try to describe it a bit more please. The answer will be quite simple but
with so many unanswered points it is hard to help you.


"jbelles" wrote:

I have several worksheets with employees ID numbers and expenses. They can
be reimbursed ½ of what they have spent up to a total of $400 on each tab.
They have a maximum of $1000 to be reimbursed for across all tabs. They might
not have expenses in each category (tab).
Is there a formula that could calculate for me which employees have reached
their maximum and which employees have not?