EXCEL

D

Donna

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

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
 
Top