1 item = total times used

[mrjackt]

example
qty=3 description = red car

qty=23 description = blue car

put under sheet 1

sheet 1 is used 15 times

qty=2 description=red car

qty=6 description = bule cars

sheet 2 is used 2 times

how to calculate on another sheet qty of red cars and blue cars

(15 x 3=red cars)sheet 1 + (sheet 2x2) = total of all

hope this makes sense...

Thanks for your help

[xlbiznes]

hi,

try this.

[mrjackt]

thanks works great

[xlbiznes]

your welcome.

[mrjackt]

Is there a limit to amount of sheets used?

[xlbiznes]

There is no such limit as long as you add up the sumif conditions for each sheet.

[mrjackt]

Im getting a #VALUE! error?

[mrjackt]

i have attached my file. Maybe this will define my lack of knowledge much better.

thanks