Forum Discussion

TheWeetek's avatar
TheWeetek
Copper Contributor
Jun 20, 2023
Solved

How to count number of products

Hey, help please. How I can count, how many pcs were sold together?   I can do =countif(C185:C201;C199) to get the number of sold product without the D column, which are number of pcs. I need th...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jun 21, 2023

    TheWeetek 

    For adding values with one more conditions use SUMIFS().

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jun 21, 2023

TheWeetek 

For adding values with one more conditions use SUMIFS().

 

TheWeetek's avatar
TheWeetek
Copper Contributor
Jun 21, 2023
hey, I was able to do it through SUMIF() finally.
thanks

Resources