I am using the following formula =COUNTIF(Sheet1!F:F,"*MEDICAL CENTER : PROPERTY : BHU") this is returning an incorrect count and I can't figure out why, there are only 9 events and my formula is returning 148. The portion in parenthesis is copied and pasted from the raw data to assure I captured it exactly as it is entered. Any suggestions on a better more precise formula?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Advice on a formula
- Thread starter datadummy
- Start date
Excel Facts
Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Upvote
0
awoohaw
Well-known Member
- Joined
- Mar 23, 2022
- Messages
- 4,670
- Office Version
- 365
- Platform
- Windows
- Web
Here is my formula for it:
| Mr Excel 8.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | ||||
| 2 | =COUNTIF($A$3:$A$14,"MEDICAL CENTER : PROPERTY : BHU") | 9 | ||
| 3 | MEDICAL CENTER : PROPERTY : BHU | |||
| 4 | MEDICAL CENTER : PROPERTY : BHU | |||
| 5 | ajfdkljfajd | |||
| 6 | MEDICAL CENTER : PROPERTY : BHU | |||
| 7 | MEDICAL CENTER : PROPERTY : BHU | |||
| 8 | dsfsgs | |||
| 9 | dfajfk | |||
| 10 | MEDICAL CENTER : PROPERTY : BHU | |||
| 11 | MEDICAL CENTER : PROPERTY : BHU | |||
| 12 | MEDICAL CENTER : PROPERTY : BHU | |||
| 13 | MEDICAL CENTER : PROPERTY : BHU | |||
| 14 | MEDICAL CENTER : PROPERTY : BHU | |||
Sheet18 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A2 | A2 | =FORMULATEXT(B2) |
| B2 | B2 | =COUNTIF($A$3:$A$14,"MEDICAL CENTER : PROPERTY : BHU") |
Upvote
0
I took the context of the formula and put it in a single cell and followed your steps and it returned 1. Is this what you would anticipate?
Upvote
0
No the formula is on Sheet2.
Upvote
0
Similar threads
- Solved
