Need help with formual that will sum up a column under specific conditions.

**Caulerpa** · 01-15-2012, 05:28 PM

In column A I have dates
In column B I have project abbreviations (e.g.: "AX", "LB", "VH"...)
In Column C I have progress

I want to construct a formula that would add up the progress (these are footages) only if the program is the right abbreviation and the month is January. My goal is to have a table that will track the total progress for each program for every month during the year.

Thank you for any help you can offer!

**Haseeb Avarakkan** · 01-15-2012, 05:39 PM

You can use SUMIFS or Pivot Table.

Can you please attach a dummy, so we can see the data layout. On bottom click Go Advanced, then Manage Attachments, browse & upload it.

**jeffreybrown** · 01-15-2012, 05:39 PM

Maybe...

=SUMPRODUCT(--(MONTH($A$1:$A$10)=1),--ISNUMBER(MATCH($B$1:$B$10,{"AX","LB","VH"},0)),$C$1:$C$10)

This is based off of column A dates being actual dates

**Caulerpa** · 01-17-2012, 11:15 AM

Jeffreybrown you are an excel angel. Thank you so much!

**jeffreybrown** · 01-17-2012, 11:52 AM

You are very welcome and thank you for the comment, but compared to somebody such as Haseeb I have a lot to learn about formulas.

As a matter of fact, I was looking forward to hearing what Haseeb had to say about how to do this with a Sumif so we can abandon the Sumproduct

**Haseeb Avarakkan** · 01-17-2012, 02:40 PM

Say,

Column A Dates
Column B types like AX, LB, VH etc..
Column C values

F1 enter the Year eg: 2012
E2 to down enter the months like January, or jan etc...

Then F2, copy down.

=SUM(SUMIFS($C:$C,$A:$A,">="&$E2&F$1,$A:$A,"<="&EOMONTH(1&$E2&K$1,0),$B:$B,{"AX","LB","VH"}))

if you have more years enter them G1, H1 etc... then copy across formula. Pivot Table also workable.