If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
SumIf Function
pleasae learing me sumproduct formula example
"Don Guillett" wrote: =sumproduct((a2:a22="Jay")*(b2:b22=1)) to sum c based on that criteria =sumproduct((a2:a22="Jay")*(b2:b22=1)*c2:c22) note that the ranges must be the same size and not complete columns -- Don Guillett SalesAid Software "jayceejay" wrote in message ... I'm trying to use the SumIf Function (as I understand its use) and I keep running into the same problems -- in many cases I have more than one criterion for addind a specific cell. Is there a way to modify SumIf to allow for multiple criteria? I try to do it in the insert function box and it gets spit back out at me. Any ideas? Jay |
|
Thread Tools | |
Display Modes | |
|
|