Formula to total text in range, if true to condition
No problem! Glad I could help
"Jayne Mae" wrote:
Thank you kindly for investing the time to help me. I sincerely appreciate
your time and assistance.
"akphidelt" wrote:
Honestly the dollar signs should not effect that much unless you are copying
the formula and pasting it. The dollar signs just add absolute reference to
those cells so if you paste that formula anywhere on the excel sheet it will
keep that same range of cells.
With out the dollar signs if you paste that formula it will increment the
rows and columns by a relative reference to where the original formula
started.
"Jayne Mae" wrote:
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
|