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