Need to compute values in 2 column's

M

michael.woosley

Hello;

I am a National Guard technician and I'm trying to determine the
following;

I have several different types of equipment from different states. I
want to count how many tanks I have that are from Kentucky and have
this result posted in a cell. I also have the same equipment that
belongs to Tennessee and I need to know how many of these same pieces
belong to Tennessee. I've tried several different formula's but with
no luck.

PLEASE HELP!!


Mike Woosley
Kentucky MATES
Ft. Knox, KY
 
B

Biff

Hi!

Assume:

A1:A100 = equipment type
B1:B100 = state

=SUMPRODUCT(--(A1:A100="tank"),--(B1:B100="Kentucky"))

Better to use cells to hold the criteria:

C1 = tank
D1 = Kentucky

=SUMPRODUCT(--(A1:A100=C1),--(B1:B100=D1))

Biff

"michael.woosley"
 
P

Peo Sjoblom

What is the way you would know where they are from, state abbreviations or
something else?

=COUNTIF(Range,"KY")

will count KY

replace Range with your actual range like for example A2:A200 or something
--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"michael.woosley"
 
Top