ExcelBanter - multiple functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - multiple functions (https://www.excelbanter.com/excel-worksheet-functions/179126-multiple-functions.html)

ronbwa

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.

Niek Otten

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.

Niek Otten

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.

All times are GMT +1. The time now is 08:29 AM.