I have the following formula:

=SUMPRODUCT(Data!$T$6:Data!$T$5000="Long
Term")*SUM(Data!$BE$6:Data!$BF$5000)/SUM(Data!$BE$6:Data!$BF$5000)
which produces the wrong answer.

Column T contains "Long Term", "Short Term", "Spot"
Column BE contains spend for January, BF for February, BG for March, etc...

I would like to calculate what percentage of year to date total spend there
is for "long term" contracts for February. This calculation would be: (Total
"long term" spend for Jan and Feb) / (Total spend year to date)