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?
Your are not logged in . Please login to post replies Click here to Login / Register
More recent discussions | Post
Murali and Sumeet Chartered Accountant
Bengaluru
CA Foundation
ANIVESH CONSULTANTS LLP
Gurgaon
CA Inter
apricus india
Pune
CA
Getmyca Consultant Pvt Ltd
New Delhi
Subrahmanyam & Sivudu CA Firm
Hyderabad
A Jaiswal and company
Lucknow
CA Final
MG Associates
Thammana & Associates
Srikakulam
B.Com
India's largest network for finance professionals
Alternatively, you can log in using: