Just learning how to use Sumproduct to search for values. Looks like a very
powerful little function. But I keep getting a #VALUE! error when I have
text in the array. Here is my formula:

=SUMPRODUCT((E70:T99=12)*(F70:U99))

If there is not a direct solution, here is my more general goal.
I have a large grid with Work Orders and Hrs in columns by release date, so
it looks something like this: (hopefully the columns will line up in your
view)

Oct Nov Dec
WO Req Dev QA WO Req Dev QA WO Req Dev QA

2 40 8 44
4 33 9
80
5 45 3
24

And in another tab I would like the data to come out like this:

WO Req Dev QA
2 40
3 24
4 33
5 45
6
7
8 44
9 80

Unfortunately the actual sheet is a bit more complicated and has text
scattered within the data. I found that if I limit the Sumproduct function
above to the non-text areas it works fine, but as soon as I include an area
in the array that has text, or type text into a cell in a working array, I
get the #VALUE! error.

Help please!
TIA