Sumif instead if vlookup

148 views 1 replies
Can we use sumif instead if vlookup where duplicate values exist in a table??
Replies (1)

VLOOKUP is used to retrieve data as most commonly know. 

Sumif calculates addition in a data range.

one is used to retrieve data, other is used to add multiple data.

what is your purpose please?


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register