Re: SUMPRODUCT trouble

I could only get your formula to work by formatting the year column to General and then taking out the " " around 2006 in the formula i.e. =2006 instead of ="2006".

Wonder why.

You can adjust your formula to try out on a smaller data range, say 5 rows and 4 columns. Then click on the cell that holds the formula and click tools>formula auditing>evaluate formula to see the steps unfold.

Epinn

"Greg Snidow" <GregSnidow@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0952B758-C9BD-4D6F-94DB-F3C0317E4978@xxxxxxxxxxxxxxxx
Greetings all. I am very new to work*** formulas and I am having trouble
getting sumproduct to work. here is my formula, as I found it in many places
here:

=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.



.