Can I use the IF formula to total certain items in a column?
 

In column B1, I would like the total of all items in column E that correspond
with the same code from column A that is in column D. Column A is the total
column, column D is the breakdown per employee.

A B C D E F
200220 300320 4.00
300310 500310 39.25
300320 300320 5.00
300330 300330 9.75
300340 300310 20.00
400310 300330 19.00
500310 300330 8.00
600310 300330 8.00
700310 300320 4.66
700320 300320 28.25
800310 300320 28.25
900110 300340 36.00
0.00 0.00 500310 31.25
0.00 600310 38.50
300320 4.50
300320 4.50
300320 18.40
300320 4.50
300320 4.50
TOTAL 316.31 0

Can I use the IF formula to total certain items in a column?
 

It sounds like you are looking for SumIf

=SUMIF($D$2:$D$100, $A2, $E$2:$E$100)
placed in B2
--
HTH...

Jim Thomlinson


"Donna" wrote:

In column B1, I would like the total of all items in column E that correspond
with the same code from column A that is in column D. Column A is the total
column, column D is the breakdown per employee.

A B C D E F
200220 300320 4.00
300310 500310 39.25
300320 300320 5.00
300330 300330 9.75
300340 300310 20.00
400310 300330 19.00
500310 300330 8.00
600310 300330 8.00
700310 300320 4.66
700320 300320 28.25
800310 300320 28.25
900110 300340 36.00
0.00 0.00 500310 31.25
0.00 600310 38.50
300320 4.50
300320 4.50
300320 18.40
300320 4.50
300320 4.50
TOTAL 316.31 0

Can I use the IF formula to total certain items in a column?
 

Thank you! That's exactly what I was looking for.

"Jim Thomlinson" wrote:

It sounds like you are looking for SumIf

=SUMIF($D$2:$D$100, $A2, $E$2:$E$100)
placed in B2
--
HTH...

Jim Thomlinson


"Donna" wrote:

In column B1, I would like the total of all items in column E that correspond
with the same code from column A that is in column D. Column A is the total
column, column D is the breakdown per employee.

A B C D E F
200220 300320 4.00
300310 500310 39.25
300320 300320 5.00
300330 300330 9.75
300340 300310 20.00
400310 300330 19.00
500310 300330 8.00
600310 300330 8.00
700310 300320 4.66
700320 300320 28.25
800310 300320 28.25
900110 300340 36.00
0.00 0.00 500310 31.25
0.00 600310 38.50
300320 4.50
300320 4.50
300320 18.40
300320 4.50
300320 4.50
TOTAL 316.31 0