G Guest Jul 22, 2004 #1 I am trying to set up a formula with two conditions. I want my data to be if there is info in column A=A name, and if in column B=>270, then I want to sum column C
I am trying to set up a formula with two conditions. I want my data to be if there is info in column A=A name, and if in column B=>270, then I want to sum column C
F Frank Kabel Jul 22, 2004 #2 Hi try =SUMPRODUCT(--(A1:A100="name"),--(B1:B100>=270),C1:C100) -- Regards Frank Kabel Frankfurt, Germany Donna said: I am trying to set up a formula with two conditions. I want my data Click to expand... to be if there is info in column A=A name, and if in column B=>270, then I want to sum column C
Hi try =SUMPRODUCT(--(A1:A100="name"),--(B1:B100>=270),C1:C100) -- Regards Frank Kabel Frankfurt, Germany Donna said: I am trying to set up a formula with two conditions. I want my data Click to expand... to be if there is info in column A=A name, and if in column B=>270, then I want to sum column C
