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 titled "Initial Value." The rest of the columns have mm/dd/yyyy headers, so 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'm 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

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.