The dollar signs seem to have made a big difference along with the quotes. I
had tried the quotes before and my formula still failed. Can you help me
understand why the $ is so important to this working correctly?

"akphidelt" wrote:

Check that, typo on my part

=Countif($E$3:$E$83,"UP")

"akphidelt" wrote:

Try this

=Countif($E$3:$E$E83,"UP")

"Jayne Mae" wrote:

=COUNTIF(E3:E82,UP)

I have used this to (hopefully) go to the named range and only total the
work orders that are designated UP.

It's seriously driving me nuts! Thanks

"akphidelt" wrote:

Not sure why countif wouldn't work in this situation. Can you show an example
of what formula you've been trying?

"Jayne Mae" wrote:

Hello All,

I am seeking advice on a formula to give me a count of work order types. I
have already spent a few hours getting "close" but not close enough :-(

I have a rows of work orders. There is a column that designates the work
order type. Is there a formula that would count and total each type?

I have tried countif, and sumif. When I check the formula, excel tells me it
contains a constant. GRRRR

Any help would be sincerely appreciated.

Jayne Mae