Key thing to remember is that if you are counting strings you have to tell
excel that you want it to count a string so it has to be placed between " ".

Glad it worked!

"Jayne Mae" wrote:

Got it! Thank you so much! It's works and I am a happy camper :-)

"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