SUMPRODUCT Formula

I'm having a heck of a time trying to figure out this formula.
I'm trying to calculate YTD operating expenses as a percent of sales.
the only twist is I need to subtract depreciation expense from operating expense.

I don't know why but my formula is resulting in a HUGE number.

Please see attached.

Thanks!

The formula is in cell C12 and should equal to C21

It's the order of operations.

The formula you have in C22 to show how your math is done
=-(-800+70)/C17

However, the formula you put in C12 is actually doing
=-800--70/C17

With the ()'s omitted, devision and multiplication are done before addition and subraction.
So it's doing
=-800-(-70/C17)

The -70/C17 is done first.

You need to add those () to the formula in C12, and add a - to the front
Try

=-(SUMPRODUCT(($B$4:$B$8="Total Operating Expenses")*($C$3:$N$3<=$A$1)*($C$4:$N$8))-SUMPRODUCT(($B$4:$B$8="Total Depreciation")*($C$3:$N$3<=$A$1)*($C$4:$N$8)))/SUMPRODUCT(($B$4:$B$8="Total Revenue")*($C$3:$N$3<=$A$1)*($C$4:$N$8))

OMG....I feel.....dumb.....but thanks so much!

You're welcome.