Sumif instead if vlookup
Sandeep Sharma (Accounts executive) (552 Points)
14 June 2021
Can we use sumif instead if vlookup where duplicate values exist in a table??
1 Replies
yasaswi gomes
(My grammar is 💯 good I)
(7290 Points)
Replied 15 June 2021
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?
Recent Topics
- How can I check the platform number for my train?
- Gratuity under CTC
- GST refund paid as estimated tax liability
- Salary Income and Professional services income
- Sec 54 and TDS on sale of property
- Airbnb Manager - I manage properties for owners
- Wrong head ed for late fee
- Inter Company trnafer
- Job work-Reg
- Who is liable to pay GST if bank charges excl GST
Related Threads
Trending Online Classes
-
Landmark Judgments: Important Provisions of the EPF & ESI Act interpreted by the Honorable Supreme Court of India
Mr.Balamurugan Ranganathan15 November 2024
CAclubindia
