=SUMPRODUCT(--(Current!J1:J1000="Value A"),--(Current!H1:H1000180))

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Dave" wrote in message
...
Hello,

Having trouble getting Excel to compute a value based on two columns on
another sheet. What I need it to do is see if column A has the value I
specify, then look in column B and see if that date figure is greater than
180 days, and then count it. So I might have 45 that meet criteria A, but
then need to find items in that subset that meet criteria B.

My attempt was
=countif(if(COUNTIF(Current!J:J,"Value A",Current!H:H,"180"))) which
isn't
completing.

Any help is appreciated. Thanks!