Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumIF with 2 Conditions
I'm needing to do a SUMIF function with two conditions, how do I do this?
For Example; SUM the cells in AD7:AD294 when B4:B294 equal "F", AND when AD7:AD294 are less than 200 Also, is there a way that if a column has dates and numbers in it you can have a formula that disregards the dates and only sums the numbers rather than treating the dates as numbers also? Thanks!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumIF with 2 Conditions
Hi,
=sumproduct(--($B$4:$B$294="F"),--($AD$4:$AD$294<200),$AD$4:$AD$294) "lightbulb" wrote: I'm needing to do a SUMIF function with two conditions, how do I do this? For Example; SUM the cells in AD7:AD294 when B4:B294 equal "F", AND when AD7:AD294 are less than 200 Also, is there a way that if a column has dates and numbers in it you can have a formula that disregards the dates and only sums the numbers rather than treating the dates as numbers also? Thanks!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumIF with 2 Conditions
Hi lightbulb:
Consider: =SUM(IF((B7:B294="F")*(AD7:AD294200),AD7:AD294)) -- It must be treated as an array so press F2 and then CTRL-SHIFT-ENTER -- Tony. "lightbulb" wrote: I'm needing to do a SUMIF function with two conditions, how do I do this? For Example; SUM the cells in AD7:AD294 when B4:B294 equal "F", AND when AD7:AD294 are less than 200 Also, is there a way that if a column has dates and numbers in it you can have a formula that disregards the dates and only sums the numbers rather than treating the dates as numbers also? Thanks!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumIF with 2 Conditions
Hi lightbulb,
Consider: =SUM(IF((B7:B294="F")*(AD7:AD294200),AD7:AD294)) -- It must be treated as an array so press F2 and then CTRL-SHIFT-ENTER. Tony. Press "Yes" if useful to you. "lightbulb" wrote: I'm needing to do a SUMIF function with two conditions, how do I do this? For Example; SUM the cells in AD7:AD294 when B4:B294 equal "F", AND when AD7:AD294 are less than 200 Also, is there a way that if a column has dates and numbers in it you can have a formula that disregards the dates and only sums the numbers rather than treating the dates as numbers also? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with 2 conditions | Excel Worksheet Functions | |||
Can I have two conditions in a SUMIF? | Excel Worksheet Functions | |||
SUMIF Two Conditions | Excel Worksheet Functions | |||
sumif with 2 conditions ?? can this be done?? | Excel Worksheet Functions | |||
SUMIF with two conditions | Excel Discussion (Misc queries) |