Forum Discussion

Copper Contributor

Oct 02, 2024

COUNTIF 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...

excel

Formulas and Functions

Harun24HR

Bronze Contributor

Oct 02, 2024

What do you mean by Buchanon combined? What problem are you facing to use COUNTIF() function? Can you please share a sample file via one-drive or google-drive and then show your desired output?

jryanks35

Copper Contributor

Oct 02, 2024

Harun24HR Thanks for responding. Above in my post, I posted a link to another Microsoft page that shows an Excel example.

jryanks35
Copper Contributor
Oct 02, 2024
jryanks35 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
- Harun24HR
  Bronze Contributor
  Oct 03, 2024
  jryanks35 SUMIFS() would work here.
  =SUMIFS(B:B,A:A,D6)
  
  sumifs.xlsx9 KB
- Patrick2788
  Silver Contributor
  Oct 02, 2024
  jryanks35
  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_Lewin
  Silver Contributor
  Oct 02, 2024
  jryanks35
  Create a pivot table or use SUMIFS().