Summing with multiple conditions

  • Thread starter Thread starter IT
  • Start date Start date
I

IT

I asked a question yesterday regarding counting with multiple
conditions. The sumproduct answer worked great. Now I need to sum the
totals in a column based on 2 conditions.

Column A willl equal either x, y or z
Column b will equal either a, b or c
Column c will be times in hh:mm:ss format

What I am trying to do is look at column and and b and where the
values are, for instance, x and b, sum the total time in column c
where those 2 criteria are met.

I tried the following, but the result, comes back as though it is a
false result:

=IF(AND(JOBS!A:A="x",JOBS!B:B="b"),SUM(JOBS!C:C),"")

In the formula, I have x and b replaced with a cell reference.

Any help appreciated. Thanks.
 
I may be trying to do something similar to what you're working on. Look
over the following. We may be able to help each other.

I'm trying to set up a time sheet at work using excel. I have set up
my sheet to calculate each day of the week individually. (M, T, W, Th,
F, Sa, Su).

I was able to use the following formula to calculate an employee's
hours for one day of the week.
=min(E4-D4-L4,8/24)

I want to add the total hrs calculated for each day of the week. I'm
really unsure of what formula to use for this calculation and would
greatly appreciate your assistance.

The closest formula I can think of since it's looking for a value is
the following formula:
=sum(e4-d4-l4,8/24)+(s4-r4-z4,8/24)+(ag4-af4-an4,8/24)+(au4-at4-bb4,8/24)+(bi4-bh4-bp4,8/24)+(bw4-bv4-cd4,8/24)+(ck4-cj4-cr4,8/24).
Can you tell me what's wrong with this formula or tell me how to enter
a correct formula to add these columns. Below is a sample format.

In Out Reg Hrs Totaled Lunch In Lunch Out
Lunch Hrs Totaled OT Hrs
 
Back
Top