count

  • Thread starter Thread starter nkob
  • Start date Start date
N

nkob

does anybody know how i can do the following. i have a spreadsheet with the
following. fields.

country, weight, dates

I want to do a countif the country = argentina and the weight = 2lbs.

tx in adavance.
 
Any dates?

=SUMPRODUCT((A2:A100="Argentina")*(B2:B100=2))

assuming that you enter pounds as numbers and not 2lbs
 
thank you so much. it works beautifully.


Peo Sjoblom said:
Any dates?

=SUMPRODUCT((A2:A100="Argentina")*(B2:B100=2))

assuming that you enter pounds as numbers and not 2lbs

--

Regards,

Peo Sjoblom
Click to expand...
 
Back
Top