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 Topic
- PPF Interest Exempt - But what drop down to choose
- Itr2 or itr3 intraday trade 1 loss of 70 paise
- Calculation of IT
- CA FINAL FR IndAS 33 Doubt(Corrected)
- Clarification Needed: Reporting Accrued vs Paid FD
- TDS on prize given to participants in Livestock sh
- TDS related matter - 194 IA
- Research: How do CA firms handle GSTR-2B reconcili
- CA FINAL FR IndAS 33 Illustrtion 14
- Taxation on Sale of old Jewellery Received at Marr
Related Topics
CAclubindia
