Multiple Criteria for SUMIF

[InfamousQBert]

I need to write a formula that sums info where the customer in column A matches another field and the amount in column B is >0. I've found lots of variations of these types of formulas, but none of them are working. Can someone help?

 

[Aladin Akyurek]

I need to write a formula that sums info where the customer in column A matches another field and the amount in column B is >0. I've found lots of variations of these types of formulas, but none of them are working. Can someone help?

Are you trying to sum the positive figures in column B when column A matches a certain criterion ("another field") you didn't specify? If so, something like:

=SUMPRODUCT(
   --($A$2:$A$100=E2),
   --($B$2:$B$100 > 0),
   $B$2:$B$100)

where E2 houses a value (criterion) the range in column A must meet.

 

[InfamousQBert]

I'm getting a #VALUE when I use that.

=SUMPRODUCT(--('All Detail'!$E$3:$E$105=2174),--('All Detail'!$G$2:$G$105>0),'All Detail'!$G$2:$G$105)

Where the "2174" is, I tried linking to the cell and just typing in the value (it's a customer number on our system). Linking to it gave me an error and typing it in gave me the #VALUE.

 

[Joe4]

All your ranges must be the same size. Note that your first one starts in row 3 while the other two start in row 2.