| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there an equivalent function?
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there an equivalent function?
Ayo,
In general: = SUMPRODUCT((Range1=Cond1)*(Range2=Cond2)*(Range3)) where Range 3 has the numbers to sum. Each of the ranges must have the same number of rows or columns. HTH, Bernie MS Excel MVP "Ayo" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there an equivalent function?
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there an equivalent function?
Thanks Bernie.
"Bernie Deitrick" wrote: Ayo, In general: = SUMPRODUCT((Range1=Cond1)*(Range2=Cond2)*(Range3)) where Range 3 has the numbers to sum. Each of the ranges must have the same number of rows or columns. HTH, Bernie MS Excel MVP "Ayo" wrote in message ... 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. |
|
#5
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 | |||
Linear Mode
