=SUMPRODUCT--(B1:B100=2800650),--(C1:C100=30200028))

replace the hard coded values with cells like


=SUMPRODUCT--(B1:B100=D2),--(C1:C100=E2))

where you put the criteria in the cells, just a heads up, if the values are
text numbers the formula will return zero, if so try to enclose the criteria
in quotes like

"2800650"


--


Regards,


Peo Sjoblom




"chelle" wrote in message
...
I'm trying to add the values in a column if the row includes two different
criteria:

2800650 1 30200028
2800650 1 30200028
2800650 1 30200028
2800750 1 30200028


if the value in column a="2800650", and the value in colum c="30200028"
then
count b1:b4
(in this case would = 3)