Using Sumif for 2 criterias

J

Jarod

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.
 
B

Bernie Deitrick

Jarod,

In A12, enter

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

HTH,
Bernie
MS Excel MVP
 
B

Bernie Deitrick

I'm sorry - my mind stopped on 'calculate counts'

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

For sums

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

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top