Formula for inclusive of Vlookup,Sum & Count if

[azeem721]

Dear Team,

How could i do vlookup,countif, & Sum at once in excel as i have 200+ of enteries in my hand.

 

[BrianMH]

Check out the sumproduct formula. This will likely do what you need. If you gave us an example of the data and the output you wish to see we could probably help further.

 

[etaf]

can you provide an example of exactly what you are trying to do, theres lots of different ways to use those functions together