What formula do I use to count if value in other column?

L

LoriT

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
 
S

Stefi

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:
 
L

LoriT

Let me be more clear, info comes from sales table where trailer sale is
600.00, but I want it to count as 1 sale of a trailer for county of adam. I
also need to count 2 trailer columns for new & used. But count only sales in
trailer column that are a specific county.
Thank you
 
S

Stefi

If your original table (Sheet1) is something like this
Trailer Bike County
600 adam
400 adam
800 mara

then in sheet2
County Trailer Bike
adam 1 1
mara 1 0

=SUMPRODUCT(--(Sheet1!$C$2:$C$4=$A2),--(Sheet1!A$2:A$4>0))

entered in B2 and copied to the right and down gives the required result.
You have to adjust ranges!!!

Regards,
Stefi

„LoriT†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with lots of formulas 3
How to do this formula??? 2
How do I get the sum of vlookup? 3
Calculate the median value before a specified list 0
COUNTIF not including something in both columns 2
return values in the table with multiple conditions 2
If formula with table look up 3
Trying to count based on multiple criteria & cell comparisons 4

Top