Dividing a sumifs() statement by another sumifs() statement - Problem: Second sumifs() not recognizing valid ranges.

[OwenNeedsVBAHelp]

Hi,

I am trying to divide the result of one sumifs() statement by the result of another sumifs() statement, but the sum range and criteria ranges referenced in the second statement are not working.The ranges are valid but they are not highlighted in the sheet and the formula returns an error. It doesn't return a specific error, just the generic "Looks like you are trying to type a formula but the syntax is wrong blah blah if you put an equal sign excel thinks its a formula blah blah." I've looked it over a million times but can't seem to identify what part is incorrect.

Below is the formula, please lmk what I'm doing wrong here. I know the parentheses aren't all necessary but I got to the point where I just started trying random stuff to make it work, I ran into the same problem even with efficient parentheses.

=((sumifs($H$2:$H$3195, $C$2:$C$3195, $v3, $J$2:$J$3195, <5))/(sumifs($Q$2:$Q$196, $J$2:$J$3195, <5, $C$2:$C$3195, $v3)))

 

[Fluff]

The two <5 should be in quotes "<5"

 

[jkpieterse]

Perhaps it should read:
=((sumifs($H$2:$H$3195, $C$2:$C$3195, $v3, $J$2:$J$3195, "<5"))/(sumifs($Q$2:$Q$3195, $J$2:$J$3195, "<5", $C$2:$C$3195, $v3)))