In case there's anyone out there thinking about this problem, or who is interested in the answer, I figured it out!

=SUM(IF(B:B=Q3,F:O))

This formula does exactly what the first one did, but allows for text headers, ONLY IF ctrl+shift+enter is used when inputting the formula, not just enter.

Thanks to anyone who tried figuring this one out.