Sum values depending on prefefined criterias

Hi all

I am using excel to calculate some statistics:

I have the following list

1) 2)
a) e n
b) e y
c) e y
d) e y
e) f n
f) f n
g) g y

I want excel to "calculate" the following values

e 1 n
e 3 y
f 2 n
f 0 y
g 0 n
g 0 y

I hope anybody can help me.

Best Regards

=sumproduct(--(A1:A100="e"),--(B1:B100="n"))

etc

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jakees" <[email protected]> wrote in message
news:[email protected]...
> Hi all
>
> I am using excel to calculate some statistics:
>
> I have the following list
>
> 1) 2)
> a) e n
> b) e y
> c) e y
> d) e y
> e) f n
> f) f n
> g) g y
>
> I want excel to "calculate" the following values
>
> e 1 n
> e 3 y
> f 2 n
> f 0 y
> g 0 n
> g 0 y
>
> I hope anybody can help me.
>
> Best Regards

Bob, cool stuff. How about using the same formula where the criteria is based on if the number are alike... following is an example:

A-------B------C
1-------2------
1-------3------2
2-------3------
3-------7------7
6-------4------
6-------4------12
7-------3------
7-------2------
7-------1------21
2-------3------6

Column A = Item Number
Column B = Qty of Item per location
Column C = Total Qty of Item in all locations

I look forward to your help!

Thanks,
Dee

Opps I made a typo in the numbers, the following is correct:

Also, let me try to explain it better too...

Bob, cool stuff. How about using the same formula where the criteria is based on if the item number are the same... following is an example:

A--------------B------C
DOG55-----------2------
DOG55-----------3------
CAT22------------3------
MOUSE66---------7------7
DOG55-----------4------9
CAT22------------4------7
RABBIT44---------3------
RABBIT44---------2------
MONKEY66-------1------1
RABBIT44---------3------8

Column A = Item #
Column B = Qty of Item per location
Column C = Total Qty of Item in all locations

I look forward to your help!

Thanks,
Dee