| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there an equivalent function?
Thanks Jacob.
"Jacob Skaria" wrote: You can use SUMPRODUCT() to sum To sum c based on conditions in A and B =SUMPRODUCT(--(A1:A10=D1),--(B1:B10=D2),C1:C10) If this post helps click Yes --------------- Jacob Skaria "Ayo" wrote: I am trying to sum up a column base on the conditions in 2 other columns. I know Excel 2007 has SUMIFS(), but I need something that is equivalent for Excel 2003. I used SUMPRODUCT before, but that is just to count numbers based on more than 2 conditions. Most of the people that will be using this file still have Excel 2003, that is why I need something compatable to 2003. Any ideas? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NZ function equivalent in Excel | Excel Worksheet Functions | |||
| VBA Equivalent for Excel Function | Excel Programming | |||
| Function Equivalent need | Excel Worksheet Functions | |||
| equivalent for function , please for help | Excel Worksheet Functions | |||
| VBA equivalent for SQL 'IN' function | Excel Programming | |||
Hybrid Mode
