Pulling data from 2 columns for a total
 

I have 2 columns, one labeled "unit" and the other "injury type". So there
are about 8 different units all numbered like "2W, 2E, 3W, 3E, etc." and the
injury types has "head, eye, hand, etc". I need help to create a formula,
for example that will pull out all the head injuries that happend in 2W. Is
this possible?

Not sure what you mean by "pull out" or "pulling" - but if you want to COUNT
them, see

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Since it's urgent, you can use

=SUMPRODUCT((A1:A10="2W")*(B1:B10="Head))

If you want to do something other than count, like pulling them to some
other range, post back.


"Urgent" wrote in message
...
I have 2 columns, one labeled "unit" and the other "injury type". So
there
are about 8 different units all numbered like "2W, 2E, 3W, 3E, etc." and
the
injury types has "head, eye, hand, etc". I need help to create a formula,
for example that will pull out all the head injuries that happend in 2W.
Is
this possible?

Hi
=SUMIF(A1:A100,"2W",B1:B100)

--
Regards
Frank Kabel
Frankfurt, Germany

Urgent wrote:
I have 2 columns, one labeled "unit" and the other "injury type". So
there are about 8 different units all numbered like "2W, 2E, 3W, 3E,
etc." and the injury types has "head, eye, hand, etc". I need help
to create a formula, for example that will pull out all the head
injuries that happend in 2W. Is this possible?

Hi
sorry, forget this use
=SUMPRODUCT(--(A1:A100=""w"),--(B1:B100="Head"))

--
Regards
Frank Kabel
Frankfurt, Germany

Frank Kabel wrote:
Hi
=SUMIF(A1:A100,"2W",B1:B100)


Urgent wrote:
I have 2 columns, one labeled "unit" and the other "injury type". So
there are about 8 different units all numbered like "2W, 2E, 3W, 3E,
etc." and the injury types has "head, eye, hand, etc". I need help
to create a formula, for example that will pull out all the head
injuries that happend in 2W. Is this possible?