multiple functions

  • Thread starter Thread starter ronbwa
  • Start date Start date
R

ronbwa

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.
 
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

| 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.
 
Sorry, should be

=COUNTA(INDIRECT("B1:B"&MATCH(D1,A1:A7,0)))


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
 
Back
Top