| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple functions
Is it possible to use VLOOKUP and COUNTA in the same formula? I want to find
a value with VLOOKUP and then I want to count entries in column up to and including value found with VLOOKUP. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple functions
With your data in A1:B7 and your search argument in D1:
=SUM(INDIRECT("B1:B"&MATCH(D1,A1:A7,0))) -- Kind regards, Niek Otten Microsoft MVP - Excel "ronbwa" wrote in message ... | Is it possible to use VLOOKUP and COUNTA in the same formula? I want to find | a value with VLOOKUP and then I want to count entries in column up to and | including value found with VLOOKUP. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple functions
Sorry, should be
=COUNTA(INDIRECT("B1:B"&MATCH(D1,A1:A7,0))) -- Kind regards, Niek Otten Microsoft MVP - Excel "ronbwa" wrote in message ... | Is it possible to use VLOOKUP and COUNTA in the same formula? I want to find | a value with VLOOKUP and then I want to count entries in column up to and | including value found with VLOOKUP. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple if functions with sum | Excel Worksheet Functions | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
| multiple if functions | Excel Worksheet Functions | |||
| Multiple functions | Excel Worksheet Functions | |||
| How do I use multiple functions? | Excel Worksheet Functions | |||
Linear Mode
