how can i get this work? =sumif(a1:a100,3,b1:z100) thanks in advance
P Peo Sjoblom Apr 19, 2005 #2 You cannot use sumif like that, it needs same sized ranges =SUMPRODUCT((A1:A100=3)*(B1:Z100))
