Count

[j4ymf]

Hello

I was wondering if someone could help me write a formula to count my stock.
In Cell I6 i would like to count all my stock which is in the range of A4:B15, is this possible or would i need to create the table differently

Thank you in advance

 

[Habtest]

Like this?

=SUMIF($A$4:$A$15,F6,$B$4:$B$15)

 

[j4ymf]

Like this?

=SUMIF(A4:A15,F6,B4:B15)

Habtest, you are a start - Thank you for your help

 

[Habtest]

Glad to help. Please note the absolute reference if you are to replicate the formula for "Mastic"

 

[maabadi]

Count or Sum? Or Both
Count:

=Countif($A$4:$A$15,F6)

Sum

=SUMIF($A$4:$A$15,F6,$B$4:$B$15)

Both:

=SUMIF($A$4:$A$15,F6,$B$4:$B$15) & " , " & Countif($A$4:$A$15,F6)