Why are we using SUMIF to transfer data instead of using VLOOKUP?
It looks to me that we are transferring the amounts from the years 2016, 2017, and 2018 to the Database sheet. However, why are we not using vlookup to transfer this data?
Cause, if there is no match, VLOOKUP returns #N/A. When using SUMIFS it return 0 where no match. So we can have information about sum of rows.
there are two reason
1. Zaruhi answered it
2. if there is multpile same code then it will sum the amount for that code.