formula troubles

[JohnE]

I have a worksheet (Info) that has a few thousand entries
to it. I also have a summary sheet (Summary). Rather
then having to go each month and go thru the counting and
totalling process I am trying add formulas to the summary
sheet. An example of what I am trying to do is to have a
cell in the summary sheet count the following;
Info column H is 6 and Info column T is >= to a date and
Info column U is < a date.
How would a formula like this get constructed?
Thanks.
*** John

 

[Frank Kabel]

Hi
try something like
=SUMPRODUCT(--(H1:H1000=6),--(T1:T1000>=DATE(2004,1,1)),--(U1:U1000<DAT
E(2004,7,1))

for more about using SUMPRODUCT see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html