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

D

Donna

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
 
J

Jim Thomlinson

It sounds like you are looking for SumIf

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to total items if they fall between a date range 1
Subtracting minutes in an +IF formula 13
Counting number of days up to an empty cell then start over again 1
How to total itmes if they fall between a date range 1
find common text in cell in column in sheet then return total amou 1
Formula to sum based on a change in another column 2
I want to write a formula with IF & AND & OR, (I think) 1
if a word is in a cell I want the total in that column 3

Top