sumif help please

P

plumfin

I have a table, with a drop down list with 5 components in column A, and then
if it is "parts" with a corresponding cost of £100, for instance, I need to
sub total this in a cell. I need to do this for all 5 drop down list
components and I am stuck! Help - thanks, Kelly
 
P

Pete_UK

Suppose your costs are in column E with your components in column A.
List your 5 components somewhere (eg M1:M5), then in N1 you can enter
this formula:

=SUMIF(A:A,M1,E:E)

Then copy this down into N2:N5.

Hope this helps.

Pete
 
Top