Hello, I've been trying to use unique values in one column to determine what the yearly sum is?

Jack Bidlack

In the above screen shot, I want to use the Job Family value to add up any amounts that match for the year. I have tried SUMIF, SUMIFS, COUNTIF,.... I keep getting #unparseable error. Here is my formula:

=SUMIFS(Program1:Program5, ="PAR", JAN1:JAN5, >0, FEB1:FEB5,>0, MAR1:MAR5, >0, APR1:APR5, >0 MAY1:MAY5, >0, JUN1:JUN5, >0, JUL1:JUL5, >0, AUG1:AUG5, >0, SEP1:SEP5, >0, OCT1:OCT5, >0, NOV1:NOV5, >0, DEC1:DEC5, >0)

Werner Gerstacker

Where is the data you want to sum up?

Your current formula only hold holds 13 condition that need to be fulfilled but nothing to add together if all these conditions actually are fulfilled.

Maybe you can achieve what you want to see by trying this:

=SUMIF(Program1:Program5, ="PAR", JAN1:JAN5) + SUMIF(Program1:Program5, ="PAR", FEB1:FEB5) + ......

And I don't think you need the '=' sign in the formula.

Werner Gerstacker

Where is the data you want to sum up?

Your current formula only hold holds 13 condition that need to be fulfilled but nothing to add together if all these conditions actually are fulfilled.

Maybe you can achieve what you want to see by trying this:

=SUMIF(Program1:Program5, ="PAR", JAN1:JAN5) + SUMIF(Program1:Program5, ="PAR", FEB1:FEB5) + ......

And I don't think you need the '=' sign in the formula.

Paul Newcome

I second @Werner Gerstacker's solution of using a SUMIF for each month column and adding them together.

Jack Bidlack

Yes that worked. I didn't know I could chain SUMIF's together. Thank You.