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
- Form 3CEAA and Form 3CEAB
- DIR 3 Web KYC
- Can i declare LTCG income as business income if I
- Stock entry in new software
- I have an EMI collection shop, what is its SAC cod
- Making payment once in quarter possible under QRMP
- Master File Documentation related
- Applicability of 44AD needs clarification
- ITC reversal in GST 3B
- Claim if ITC on stocks 19-2020 conversion from com
Related Threads
CAclubindia
