Formula Question posted earlier

  • Thread starter Thread starter bonnie
  • Start date Start date
B

bonnie

Hi,

Long story short!

Can you do a sumif with two criteria.
sumif(c:c,(not sure what to put here),h:h)

I have a store that has maybe two different names

i.e. Ferguson Enterprises #001 or FEI - Herndon

this is the same store in the same data list and I am
trying to do a sumif to capture the sales in another
column for both names.

b.
 
Hi Bonnie
if you want to look for either condition1 OR condition 2 you may try
=SUMIF(C:C,condition1,H:H)+SUMIF(C:C,condition2,H:H)

If you want to sum column H based of two conditions in two columns
(AND) try
=SUMPRODUCT((C1:C100=condition1)*(D1:D100=condition2),H1:H100)

Frank
 
Back
Top