Hi there, 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? Regards, Mario

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.

Hi Mario, I have the same question, wondering if you got an answer?

Does anybody answer these questions sometimes?

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?

Follow this topic

Last answered:

08 Nov 2022

Posted on:

16 Feb 2022

Why are we using SUMIF to transfer data instead of using VLOOKUP?

6 answers ( 0 marked as helpful)

Posted on:

28 Mar 2022

Posted on:

27 May 2022

Posted on:

15 Jul 2022

Posted on:

01 Aug 2022

Posted on:

12 Aug 2022

Posted on:

08 Nov 2022