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