| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif based on two variable
i am trying to get the sum of data from column S that meets criteria from
column b and d- I have been able to get a count using the following formula: =SUMPRODUCT(--('Sheet2'!$D$6:$D$609="Sr.")*('Sheet2'!$B$6:$B$609 ='Sheet1'!$C6)) following a few examples I found I tried the following but i keep getting #Value =SUMPRODUCT(--('Sheet2'!$D$6:$D$609="Sr.")*('Sheet2'!$B$6:$B$609 ='Sheet1'!$C6),'Sheet2'!$S$6:$S$609) what am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF With Variable Consecutive Days | Excel Worksheet Functions | |||
| SumIf for Variable Conditions | Excel Worksheet Functions | |||
| how to use a variable for the criteria in a sumif function? | Excel Worksheet Functions | |||
| Sumif with variable target | Excel Discussion (Misc queries) | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
Threaded Mode
