Problem with if conditional?

[Frank]

Is there a problem in excel when doing a conditional with a string like
"timeDH"? as it is in the examples and if I change it to use another
column that has a number the conditional works just fine so my format is
good. But it seems you need to refer to a cell with that value instead
of the number it's self.

=SUM(IF(('raw stats'!$A$1:$A$500="timeDH"), 'raw stats'!$D$1:$D$500))

 

[Jonathan Rynd]

@news4.srv.hcvlny.cv.net:

=SUM(IF(('raw stats'!$A$1:$A$500="timeDH"), 'raw stats'!$D$1:$D$500))

I think it would work better if you used the SUMIF() worksheet function
rather than trying to roll your own.

=SUMIF('raw stats'!$A$1:$A$500,"timeDH",'raw stats'!$D$1:$D$500)