L
lightbulb
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!!
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!!