S Shi Gharib Feb 5, 2008 #1 how can I use the sumif formula following 2 conditions in different cells one of the conditions is in a merged cell
how can I use the sumif formula following 2 conditions in different cells one of the conditions is in a merged cell
B Bob Phillips Feb 5, 2008 #2 =SUMPRODUCT(--(A1:A100=M1),--(B1:B100=M2),C1:C100) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
=SUMPRODUCT(--(A1:A100=M1),--(B1:B100=M2),C1:C100) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
