If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
SumIF with 2 Conditions
Hi,
=sumproduct(--($B$4:$B$294="F"),--($AD$4:$AD$294200),$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
|
|||
|
|||
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
|
|||
|
|||
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!! |
Thread Tools | |
Display Modes | |
|
|