| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using text as a "true" condition in an if function. | Excel Worksheet Functions | |||
| Search for Condition, Text based, Date Range, Occurrences | Excel Worksheet Functions | |||
| a formula to "go to" another cell if a condition is true? | Excel Discussion (Misc queries) | |||
| TRUE condition??? | Excel Discussion (Misc queries) | |||
| Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE | Excel Discussion (Misc queries) | |||
Hybrid Mode
