count

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

 

[Peo Sjoblom]

Any dates?

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

assuming that you enter pounds as numbers and not 2lbs

 

[nkob]

thank you so much. it works beautifully.

Any dates?

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

assuming that you enter pounds as numbers and not 2lbs

--

Regards,

Peo Sjoblom

 

[Peo Sjoblom]

My Pleasure..

--

Regards,

Peo Sjoblom

thank you so much. it works beautifully.