Jarod,

In A12, enter

=SUMPRODUCT((A1:A10=180)*(B1:B10<50000))

HTH,
Bernie
MS Excel MVP


"Jarod" wrote in message
...
I have a sheet that I'm using to calculate counts and sums based on values
that change daily.

I have "Days" (A1:A10) column that tells me how long an item has been
sitting idle.
I have "UPB" (B1:B10) field that tells me the value of that item.

What I'm trying to do is get a sum if days is greater than or equal to 180
and the UPB is less than 50,000.

I need to put the results in A12, if that matters to you.