jryanks35Copper ContributorOct 02, 2024COUNTIF Question I will be regarding this post made by Microsoft: https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34 In the video it shows a simple COUNTIF equation sh...Show More
jryanks35Copper ContributorOct 02, 2024Harun24HR Thanks for responding. Above in my post, I posted a link to another Microsoft page that shows an Excel example.
jryanks35Copper Contributor to jryanks35Oct 02, 2024jryanks35 Heres an example of what I am trying to find a formula for. I basically need an equation to add the total quantities for each product
Harun24HRBronze Contributor to jryanks35Oct 03, 2024jryanks35 SUMIFS() would work here.=SUMIFS(B:B,A:A,D6) sumifs.xlsx9 KBPatrick2788Silver Contributor to jryanks35Oct 02, 2024jryanks35 The simplest way to arrive at those totals is to take advantage of one the newest functions available in a fully updated Excel 365 - GROUPBY. =GROUPBY(Demo[Product], Demo[Qty], SUM) GROUPBY 10.2.xlsx19 KBDetlef_LewinSilver Contributor to jryanks35Oct 02, 2024jryanks35 Create a pivot table or use SUMIFS().
Harun24HRBronze Contributor to jryanks35Oct 03, 2024jryanks35 SUMIFS() would work here.=SUMIFS(B:B,A:A,D6) sumifs.xlsx9 KB
Patrick2788Silver Contributor to jryanks35Oct 02, 2024jryanks35 The simplest way to arrive at those totals is to take advantage of one the newest functions available in a fully updated Excel 365 - GROUPBY. =GROUPBY(Demo[Product], Demo[Qty], SUM) GROUPBY 10.2.xlsx19 KB
Detlef_LewinSilver Contributor to jryanks35Oct 02, 2024jryanks35 Create a pivot table or use SUMIFS().
