Use of ANd in work sheet

[Frank]

I'm trying to use the AND worksheet function but I can't seem to get it
to work. I only what to sum something when it meets certain criterion.

Formula below:

=SUM(SUMIF('raw stats'!$C$1:$C$500, AND('raw stats'!$C$1:$C$500 = B3,
'raw stats'!$A$1:$A$500 = "timeDH", 'raw stats'!$B$1:$B$500 =0),'raw
stats'!$D$1:$D$500)+SUMIF('raw stats'!$C$211:$C$226,B3,'raw
stats'!$D$211:$D$226)) / SUM(COUNTIF('raw
stats'!$C$171:$C$186,B3)+COUNTIF('raw stats'!$C$211:$C$226,B3))

What I'm trying to do is make the following that does what I want it
too so that I don't have to change ranges all the time and have to
figure out the ranges, i.e. where certain row id's start and end:
=SUM(SUMIF('raw stats'!$C$171:$C$186,B3,'raw
stats'!$D$171:$D$186)+SUMIF('raw stats'!$C$211:$C$226,B3,'raw
stats'!$D$211:$D$226)) / SUM(COUNTIF('raw
stats'!$C$171:$C$186,B3)+COUNTIF('raw stats'!$C$211:$C$226,B3))

Any thoughts?

Thanks,

Frank

 

[Harlan Grove]

I'm trying to use the AND worksheet function but I can't seem to get it
to work. I only what to sum something when it meets certain criterion.

...

You might consider reading all the responses you recived to the multipost of
this same message in .worksheet.functions.

http://www.google.com/[email protected]