How can I sum a column but excluded certain figures based on another cell
F Frank Kabel Nov 10, 2004 #2 Hi =SUM(B1:B100)-SUMIF(A1:A100,"X",B1:B100) or =SUMIF(A1:A100,"<>X",B1:B100) -- Regards Frank Kabel Frankfurt, Germany starrpro said: How can I sum a column but excluded certain figures based on another Click to expand... cell
Hi =SUM(B1:B100)-SUMIF(A1:A100,"X",B1:B100) or =SUMIF(A1:A100,"<>X",B1:B100) -- Regards Frank Kabel Frankfurt, Germany starrpro said: How can I sum a column but excluded certain figures based on another Click to expand... cell
