| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using sumif to sum a range of values
Is there a way to use sumif to sum a range of values based on two conditions.
In other words I would like to sum a range of values in col c if values in col b are equal to "2006" and values f are equal to "proposed". Thanks -- hwy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using sumif to sum a range of values
One way:
=SUMPRODUCT(--(B1:B100=2006),--(F1:F100="proposed"),C1:C100) for an explanation of "--", see http://www.mcgimpsey.com/excel/doubleneg.html In article , highwayman wrote: Is there a way to use sumif to sum a range of values based on two conditions. In other words I would like to sum a range of values in col c if values in col b are equal to "2006" and values f are equal to "proposed". Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using sumif to sum a range of values
=sumproduct(--(b2:b1000="2006"),--(f2:f1000="proposed"),c2:c1000)
"highwayman" wrote: Is there a way to use sumif to sum a range of values based on two conditions. In other words I would like to sum a range of values in col c if values in col b are equal to "2006" and values f are equal to "proposed". Thanks -- hwy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using sumif to sum a range of values
Fantastic, thanks
-- hwy "JE McGimpsey" wrote: One way: =SUMPRODUCT(--(B1:B100=2006),--(F1:F100="proposed"),C1:C100) for an explanation of "--", see http://www.mcgimpsey.com/excel/doubleneg.html In article , highwayman wrote: Is there a way to use sumif to sum a range of values based on two conditions. In other words I would like to sum a range of values in col c if values in col b are equal to "2006" and values f are equal to "proposed". Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using sumif to sum a range of values
Great, thank you very much.
-- hwy "Duke Carey" wrote: =sumproduct(--(b2:b1000="2006"),--(f2:f1000="proposed"),c2:c1000) "highwayman" wrote: Is there a way to use sumif to sum a range of values based on two conditions. In other words I would like to sum a range of values in col c if values in col b are equal to "2006" and values f are equal to "proposed". Thanks -- hwy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Searching a date range to output values according to a constant. | Excel Discussion (Misc queries) | |||
| How do I define a range using values in cells? | Excel Worksheet Functions | |||
| Counting by a Range of Values? | Excel Worksheet Functions | |||
| SUMIF not adding a range | Excel Discussion (Misc queries) | |||
Linear Mode
