Excel - SUMPRODUCT to exclude text column header

I am having trouble with the following SUMPRODUCT formula:


=SUMPRODUCT((B:B=Q3)*(F:O))

The problem is that column F has a text header in cell F2 titled
SUMPRODUCT works fine there.

Of course, the simplest solution is to just delete the text header in
column F, and the formula works fine, but I am stubborn and want my
headers the way I want them.

Does anyone know of a way to get SUMPRODUCT to ignore the text header in
cell F2?

Thanks!
Steve




--
sporenta

In case there is 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.




--
sporenta