I need to do this:

A B D
F H
32 3 2
3 4
44 3 3
2 3

Column A is a Length of material, Coulmns b, c, d, etc are how many pieces
apply to that length for a given type of material. There is an additional
material that holds three bars. So I need to know how many bars total I would
need based on this.

Example that doesn't work:
=SUMIF(F5:F23,H5:H23,J5:J23,L5:L23,N5:N23,P5:P23," =3",C5:C23)

Not thinking too hard, just hope someone has an answer