K kelly Apr 25, 2004 #1 If B:B contains other numbers such as 404 and 405 could I have c:c sum if B:B= 402 and 403 while A:A =312?
If B:B contains other numbers such as 404 and 405 could I have c:c sum if B:B= 402 and 403 while A:A =312?
F Frank Kabel Apr 25, 2004 #2 Hi try =SUMPRODUCT((A1:A100=312)*((B1:B100=402)+(B1:B100=403)),(C1:C100))
