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?
6 answers ( 0 marked as helpful)
Hi Mario, I have the same question, wondering if you got an answer?
Same question here.
Does anybody answer these questions sometimes?
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.
Question is, why we are using SUMIF? whats wrong with the regular SUM function?