count

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.
 
P

Peo Sjoblom

Any dates?

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

assuming that you enter pounds as numbers and not 2lbs
 
N

nkob

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...
 
Top