Thread: sumif

How would I add the cost and labor on tab cost to the main tab column name Total for each line. I am also trying to match the type and error name to get the correct price to add together

I tried the function
SUMIFS(sum(Cost!$C$2:$C$7:Cost!D2:D7),Cost!$A$2:$A$7,B2,Cost!$B$2:$B$7,C2)

One way:

=INDEX(Cost!$C$2:$C$7,MATCH(Main!$B8&Main!$C8,Cost!$A$2:$A$7&Cost!$B$2:$B$7,0))+INDEX(Cost!$D$2:$D$7 ,MATCH(Main!$B8&Main!$C8,Cost!$A$2:$A$7&Cost!$B$2:$B$7,0))

Committed with Ctrl-Shift-Enter rather than just Enter

Regards

I got a #Value error

i tried it on E2
=INDEX(Cost!$C$2:$C$7,MATCH(Main!$B2&Main!$C2,Cost!$A$2:$A$7&Cost!$B$2:$B$7,0))+INDEX(Cost!$D$2:$D$7 ,MATCH(Main!$B2&Main!$C2,Cost!$A$2:$A$7&Cost!$B$2:$B$7,0))

Not sure what you are asking here.

If you want to keep Sheet "Main" Column D
In E2

=SUM(D2,SUMIFS(Cost!$D$2:$D$7,Cost!$A$2:$A$7,B2,Cost!$B$2:$B$7,C2))

Drag/Fill Down

If you want to combine Cost and Labour in one formula

=SUM(SUMIFS(Cost!$C$2:$C$7,Cost!$A$2:$A$7,B2,Cost!$B$2:$B$7,C2),SUMIFS(Cost!$D$2:$D$7,Cost!$A$2:$A$7,B2,Cost!$B$2:$B$7,C2))

Drag/Fill Down

Note
Your profile states you are using 2003 however your file and formula are for 2007 and above.
This will not work in 2003

Note:

Committed with Ctrl-Shift-Enter rather than just Enter

Regards