Hello, I've been trying to use unique values in one column to determine what the yearly sum is?
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)
Best Answer

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.
Answers

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.

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

Yes that worked. I didn't know I could chain SUMIF's together. Thank You.
Help Article Resources
Categories
Check out the Formula Handbook template!