Other Sum Question

B

BradP

I am trying to come up with total to complete by Plant Division. All
the data is on across 1 Row.

Ex.
Job /Paint/Division /Detail /Division /Inspection /Division /Delivery
/Division

Roger - 1500.00 - C - 180.00 - C - Inspection - 125.00 - AS - 225.00 -
C


I want total for Division C and Division AS. I have a column for each
Division's Total at the end of that Row.
 
D

Domenic

Assumptions:

A1:I1 contains your labels

A2:I2 contains your data

Formula:

=SUMIF(C2:I2,"C",B2:H2)

Hope this helps!
 
D

Domenic

Having taken a look at your sample data, it looks like A2:J2 contains
your data. If this is correct, try...

=SUMIF(C2:J2,"C",B2:I2)

....which will return 1905. The cells being summed are B2 (1500), D2
(180), and I2 (225).

Hope this helps!
 
Top