Menu
Sumif instead if vlookup
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?
Recent Threads
- Login credentials and payment acknowledgement not
- Export sales not realised payment not received fro
- Capital gain account amount utilisation
- Form 26QB – Section 194-IA: TDS on Full Cons
- Indexation Benefit available or not on Calculation
- Documents for return exhibition material
- Can I set off equity losses(both short term loss a
- Input tax credit on rent to rent
- Family Pension Army
- Waste Management services
Related Threads
CAclubindia
