F
frank
can i perform a SUMIF function with more than one
criteria.
criteria.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
=SUMPRODUCT(--(rng1="value1"),--(rng2="value2"), rng_to_sum)
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
J
Jason Morin
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
you more flexibility. Nevertheless, here's an example:
=SUM(SUMIF(A:A,{"a","b","c"},B:B))
HTH
Jason
Atlanta, GA
R
RagDyeR
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!
==============================================
can i perform a SUMIF function with more than one
criteria.
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!
==============================================
can i perform a SUMIF function with more than one
criteria.
B