| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif/Vlookup
Regional Sales Florida = RSF
I need to count the number of times €œRSF€ appear in 3 ranges. Im using the below formula to do it. =COUNTIF($I$51:$I$253,B41)+COUNTIF('TSection'!$I:$ I,B41)+COUNTIF('BSection'!$I:$I,B41) The problem is that the data appeared on the cells as Regional sales Florida. How can I combine countif and Vlookup to get a result? -- Juan Carlos |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif and Vlookup | Excel Discussion (Misc queries) | |||
| COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
| countif w/vlookup | Excel Discussion (Misc queries) | |||
| vlookup and countif??? | Excel Worksheet Functions | |||
| Countif or Vlookup | Excel Worksheet Functions | |||
Threaded Mode
