Add Column Values If Other Columns Match Criteria

[gmercer82]

I am trying to add the numbers in Column J only if they match certain criteria in Columns C, E, G.

I found a formula on a page and edited it to match the cells I would like, but I just get a #VALUE error.

I have a sheet that has 10,000 rows in it and I want to add all the numbers in column J that match certain criteria in other columns.

The formula I created was:

=SUM(IF($C$2:$C$17=8/1/2012,IF($E$2:$E$17="North",if($G:$G="Phone",$J$2:$J$17,0),0))

I plan on changing the "8/1/2012" to a cell that has the date entered. I am using Excel 2003. I would like to have this eventually used for an average formula but for now if I can get the sum of J added I am happy with that.

 

[Teethless mama]

I am trying to add the numbers in Column J only if they match certain criteria in Columns C, E, G.

I found a formula on a page and edited it to match the cells I would like, but I just get a #VALUE error.

I have a sheet that has 10,000 rows in it and I want to add all the numbers in column J that match certain criteria in other columns.

The formula I created was:

=SUM(IF($C$2:$C$17=8/1/2012,IF($E$2:$E$17="North",if($G:$G="Phone",$J$2:$J$17,0),0))

I plan on changing the "8/1/2012" to a cell that has the date entered. I am using Excel 2003. I would like to have this eventually used for an average formula but for now if I can get the sum of J added I am happy with that.

=SUM(IF($C$2:$C$17=--"8/1/2012",IF($E$2:$E$17="North",if($G2:$G17="Phone",$J$2:$J$17,0),0))

press Ctrl+Shift+Enter, not just enter

 

[gmercer82]

Thanks. I will try that