| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting Index & Countif
=INDEX(COUNTIF('PAR CALC.'!A3:A133,B3),'PAR
CALC.'!C3:C133,MATCH(Answers!L4,'PAR CALC.'!AV3:AV133,0)) Is this the proper way to nest these two functions? It returns a #REF! error, but is it due to the formula or the calculation? Thanks. M.A.Tyler |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting COUNTIF | Excel Discussion (Misc queries) | |||
| If and CountIF Nesting | Excel Worksheet Functions | |||
| Nesting Index and Match Functions | Excel Worksheet Functions | |||
| nesting with countif | Excel Discussion (Misc queries) | |||
| Nesting formulae with COUNTIF | Excel Discussion (Misc queries) | |||
Threaded Mode
