Sumif with specific sum criteria

[russc1164]

I'm running a SUMIF which returns the sum of values matching COM
Sample: =SUMIF(Cust_Type,"com",Total_Bill)
Cust_Type Total_Bill
COM 1200
COM 1200
COM 1200
COM 10
COM 10
ATM 100
ATM 100

I only want the sum of those values matching COM and are greater than 10

Thanks!

 

[Marcelo Branco]

Try,

=SUMPRODUCT(--(A2:A8="COM"),--(B2:B8>10),B2:B8)

Adjust the ranges

HTH

M.

 

[hiker95]

russc1164,

Welcome to the Excel forum.

Excel Workbook
	A	B	C	D
1	Cust_Type	Total_Bill		3600
2	COM	1200
3	COM	1200
4	COM	1200
5	COM	10
6	COM	10
7	ATM	100
8	ATM	100
9
Sheet1

 

[russc1164]

That works....now I need to figure out/understand "how" it works.

Thank you.

 

[Marcelo Branco]

That works....now I need to figure out/understand "how" it works.

Thank you.

You are welcome

Take a look at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

M.