Dear KL

Thank a lots!
The formula is very useful, however, when I have new inputs in sheet 1,
sometimes it couldn' t show in sheet 2, I have to retype again and again to
make it show in sheet 2.

"KL" wrote:

Hi Summer,

In the cell [B2] of Sheet 2 write the following formula and copy it down and
to the right:

for sum of values in column [C]:
=SUMPRODUCT(--(Sheet1!$A$1:$A$10=$A2),--(Sheet1!$B$1:$B$10=B$1),Sheet1!$C$1:$C$10)

for counts:
=SUMPRODUCT(--(Sheet1!$A$1:$A$10=$A2),--(Sheet1!$B$1:$B$10=B$1))

Regards,
KL


"Summer" wrote in message
...
If I want to do the belows, what can I do?

Sheet 1
A B C
1 Com 1 Aug 100
2 Com 2 Aug 100
3 Com 2 Sept 120
4 Com 2 Oct 111
5 Com 1 Sept 111
6 Com 3 Oct 130
7 Com 4 Aug 130
: :
: :
: :

Sheet 2
A B C D
1 Aug Sept Oct ...........
2 Com 1
3 Com 2
4 Com 3
5 Com 4

If I want to sum up the number in sheet 2 of Com 1 in Aug, Com 2 in Aug,
Com
3 in Aug.............. Com 4 in Oct....etc. What formula can i use?
Thank a
lots!