Forum Discussion
Using VLookup and Sum
Hello,
I'm currently trying to use vlookup with sum to scan and sum all of my listed expenses on the "$ Incoming & Outgoing Sheet" and show me on a calender totals due that day. (or in this case display on Sheet "Summary" in cells B26:B56)
https://docs.google.com/spreadsheets/d/1Nxnf08s789VckrNd1zIhjVAfTB07H6kC/edit?usp=sharing&ouid=117193475327273587336&rtpof=true&sd=true
Hi! I have created the desired formula in cells C26:C56.
It is not necessary to use VLOOKUP() within SUMIF(). This has led to a wrong result. You used the amount as a criterion and not the date.
=SUMIF('$ Incoming & Outgoing'!$A$3:$A,A26,'$ Incoming & Outgoing'!$D$3:$D) in Excel: =sumif('$ Incoming & Outgoing'!$A:$A,A26,'$ Incoming & Outgoing'!$D:$D)
1 Reply
Hi! I have created the desired formula in cells C26:C56.
It is not necessary to use VLOOKUP() within SUMIF(). This has led to a wrong result. You used the amount as a criterion and not the date.
=SUMIF('$ Incoming & Outgoing'!$A$3:$A,A26,'$ Incoming & Outgoing'!$D$3:$D) in Excel: =sumif('$ Incoming & Outgoing'!$A:$A,A26,'$ Incoming & Outgoing'!$D:$D)