Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formulas
I'm currently summing a column of numbers using the
following formula: =sumif(BA23:BA500,"y",N23:N500) I would now like to break down the sum based on a second condition ie. only sum the column cells where the above is true and where the value of the cells in another column equals 0 or 1 or 2 etc. What I'm trying to do is derive subtotals of the sum above based on the revision level where the BA cells are set to "y". Does anyone have a suggestion? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formulas
Hi
try SUMPRODUCT. e.g. =SUMPRODUCT(--(BA23:BA500="y"),(BB23:BB500=1),N23:N500) -----Original Message----- I'm currently summing a column of numbers using the following formula: =sumif(BA23:BA500,"y",N23:N500) I would now like to break down the sum based on a second condition ie. only sum the column cells where the above is true and where the value of the cells in another column equals 0 or 1 or 2 etc. What I'm trying to do is derive subtotals of the sum above based on the revision level where the BA cells are set to "y". Does anyone have a suggestion? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formulas
Hi
make this =SUMPRODUCT(--(BA23:BA500="y"),--(BB23:BB500=1),N23:N500) -----Original Message----- Hi try SUMPRODUCT. e.g. =SUMPRODUCT(--(BA23:BA500="y"),(BB23:BB500=1),N23:N500) -----Original Message----- I'm currently summing a column of numbers using the following formula: =sumif(BA23:BA500,"y",N23:N500) I would now like to break down the sum based on a second condition ie. only sum the column cells where the above is true and where the value of the cells in another column equals 0 or 1 or 2 etc. What I'm trying to do is derive subtotals of the sum above based on the revision level where the BA cells are set to "y". Does anyone have a suggestion? . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formulas
Does SUMPRODUCT multiply the values of each array? I'm
not getting any totals when I try your recommendation. WHat are you indicating with the -- inside the first parenthesis? I'll not be able to reply until Monday but thanks for any suggestions you provide. Dale -----Original Message----- Hi try SUMPRODUCT. e.g. =SUMPRODUCT(--(BA23:BA500="y"),(BB23:BB500=1),N23:N500) -----Original Message----- I'm currently summing a column of numbers using the following formula: =sumif(BA23:BA500,"y",N23:N500) I would now like to break down the sum based on a second condition ie. only sum the column cells where the above is true and where the value of the cells in another column equals 0 or 1 or 2 etc. What I'm trying to do is derive subtotals of the sum above based on the revision level where the BA cells are set to "y". Does anyone have a suggestion? . . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formulas
Hi
see my correction. the double minus is required for both conditions (it coerces the boolean value to real numbers) -----Original Message----- Does SUMPRODUCT multiply the values of each array? I'm not getting any totals when I try your recommendation. WHat are you indicating with the -- inside the first parenthesis? I'll not be able to reply until Monday but thanks for any suggestions you provide. Dale -----Original Message----- Hi try SUMPRODUCT. e.g. =SUMPRODUCT(--(BA23:BA500="y"),(BB23:BB500=1),N23:N500) -----Original Message----- I'm currently summing a column of numbers using the following formula: =sumif(BA23:BA500,"y",N23:N500) I would now like to break down the sum based on a second condition ie. only sum the column cells where the above is true and where the value of the cells in another column equals 0 or 1 or 2 etc. What I'm trying to do is derive subtotals of the sum above based on the revision level where the BA cells are set to "y". Does anyone have a suggestion? . . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formulas
Excellent, that did the trick.
I really appreciate the help. Regards, Dale -----Original Message----- Hi make this =SUMPRODUCT(--(BA23:BA500="y"),--(BB23:BB500=1),N23:N500) -----Original Message----- Hi try SUMPRODUCT. e.g. =SUMPRODUCT(--(BA23:BA500="y"),(BB23:BB500=1),N23:N500) -----Original Message----- I'm currently summing a column of numbers using the following formula: =sumif(BA23:BA500,"y",N23:N500) I would now like to break down the sum based on a second condition ie. only sum the column cells where the above is true and where the value of the cells in another column equals 0 or 1 or 2 etc. What I'm trying to do is derive subtotals of the sum above based on the revision level where the BA cells are set to "y". Does anyone have a suggestion? . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formulas | Excel Worksheet Functions | |||
Conditional Formulas | Excel Worksheet Functions | |||
if and conditional formulas | Excel Worksheet Functions | |||
How do I set up conditional formulas | Excel Worksheet Functions | |||
conditional formulas | Excel Programming |