Formula to total text in range, if true to condition
 

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

Formula to total text in range, if true to condition
 

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

Formula to total text in range, if true to condition
 

=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

Formula to total text in range, if true to condition
 

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

Formula to total text in range, if true to condition
 

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

Formula to total text in range, if true to condition
 

Hmmm - It won't accept the formula. Says it's in error. I thought my other
one was close but it returns a big fat zero every time. I don't understand
why your formulas is accepted.

"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

Formula to total text in range, if true to condition
 

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

Formula to total text in range, if true to condition
 

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

Formula to total text in range, if true to condition
 

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

Formula to total text in range, if true to condition
 

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

Formula to total text in range, if true to condition
 

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

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