Greetings all. I am very new to worksheet formulas and I am having trouble
getting sumproduct to work. here is my formula, as I found it in many places
he

=SUMPRODUCT(--($D$31:$D$10000="Jan"),--($E$31:$E$10000="2006"),H33:H10002,N33:N10002,AF33 :AF10002,AR33:AR10002)

basically I have a month and year column, both formatted as text, then
several other columns formatted as currency, and some as number. All I get
are zeros. Thank you in advance, I am flumoxed. Also what does the $ do.