If you mean to fill in such a table

County Trailer Bike
adam 1 1
mara 1 0

then use this formula in B2 and drag it tothe right and down as required!

=SUMIF(Munka1!$C:$C,$A2,Munka1!A:A)

Regards,
Stefi

€žLoriT€� ezt Ã*rta:

I need to count if value in one column is met & if value in other column is 0
A B C
Trailer Bike County
1.00 adam
1.00 adam
1.00 mara

Count is how many times unit sold to this county for each type