SUMPRODUCT to exclude text column header

[sporenta]

I'm 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 title
"Initial Value." The rest of the columns have mm/dd/yyyy headers, s
SUMPRODUCT works fine there.

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

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

Thanks!
Stev

 

[sporenta]

In case there's anyone out there thinking about this problem, or who i
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 tex
headers, ONLY IF ctrl+shift+enter is used when inputting the formula
not just enter.

Thanks to anyone who tried figuring this one out