sumif
 

can i perform a SUMIF function with more than one
criteria.

=SUMPRODUCT(--(rng1="value1"),--(rng2="value2"), rng_to_sum)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"frank" wrote in message
...
can i perform a SUMIF function with more than one
criteria.

You can, but SUMPRODUCT or an array formula would give
you more flexibility. Nevertheless, here's an example:

=SUM(SUMIF(A:A,{"a","b","c"},B:B))

HTH
Jason
Atlanta, GA


-----Original Message-----
can i perform a SUMIF function with more than one
criteria.
.

You can ... If you want to ... in conjunction with Sum().

Usually, other functions better fit the bill for multi-criteria situations.

=SUM(SUMIF(A1:A20,{"A","B"},B1:B20))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"frank" wrote in message
...
can i perform a SUMIF function with more than one
criteria.

You can use sumproduct
check out the link below
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

-----Original Message-----
can i perform a SUMIF function with more than one
criteria.
.