Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum if
how can i get this work?
=sumif(a1:a100,3,b1:z100) thanks in advance |
#2
|
|||
|
|||
You cannot use sumif like that, it needs same sized ranges
=SUMPRODUCT((A1:A100=3)*(B1:Z100)) -- Regards, Peo Sjoblom "choice" wrote in message ... how can i get this work? =sumif(a1:a100,3,b1:z100) thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|