* SPECIAL OFFER * JOIN THE MYEXCELONLINE ACADEMY & GET ACCESS TO 500+ EXCEL TUTORIALS ON: FORMULAS, MACROS, VBA, PIVOT TABLES, CHARTS, POWER QUERY, POWER PIVOT, ACCESS PLUS MORE: 👉 www.myexcelonline.com/academy-yt
Hi John.. thanks for the video. Good technique using a concatenated helper column. If you want to skip using a helper column, any of these formula constructs would also work directly against your data table: {=INDEX($D$2:$D$55,MATCH($G$2&$H$2,$A$2:$A$55&$B$2:$B$55,0))} - requires CSE =SUMPRODUCT($D$2:$D$55*($A$2:$A$55&$B$2:$B$55=$G$2&$H$2)) {=SUM(IF($A$2:$A$55&$B$2:$B$55=$G$2&$H$2,$D$2:$D$55))} - requires CSE =SUMIFS($D$2:$D$55,$A$2:$A$55,$G$2,$B$2:$B$55,$H$2) Thanks for the inspiration to experiment and solve it in multiple ways. Thumbs up!
⭐️⭐️⭐️⭐️⭐️ FREE 10 HOUR EXCEL COURSE! VIEW NOW 👉 ua-cam.com/video/vA2NiYiGkgs/v-deo.html
* SPECIAL OFFER * JOIN THE MYEXCELONLINE ACADEMY & GET ACCESS TO 500+ EXCEL TUTORIALS ON: FORMULAS, MACROS, VBA, PIVOT TABLES, CHARTS, POWER QUERY, POWER PIVOT, ACCESS PLUS MORE: 👉 www.myexcelonline.com/academy-yt
Thank you
You're welcome
Hi John.. thanks for the video. Good technique using a concatenated helper column. If you want to skip using a helper column, any of these formula constructs would also work directly against your data table:
{=INDEX($D$2:$D$55,MATCH($G$2&$H$2,$A$2:$A$55&$B$2:$B$55,0))} - requires CSE
=SUMPRODUCT($D$2:$D$55*($A$2:$A$55&$B$2:$B$55=$G$2&$H$2))
{=SUM(IF($A$2:$A$55&$B$2:$B$55=$G$2&$H$2,$D$2:$D$55))} - requires CSE
=SUMIFS($D$2:$D$55,$A$2:$A$55,$G$2,$B$2:$B$55,$H$2)
Thanks for the inspiration to experiment and solve it in multiple ways. Thumbs up!
Nice formula Wayne! CSE = Control + SHIFT + Enter which is an Array Formula!