URGENT - Compare 2 columns and sum up the corresponding numbers in the third

[tinkletron]

Dear Excelites,

Please can you help me with this problem in excel -

Book6
	B	C	D	E	F	G	H
1	Customer	CustGrp	AccountType	Total	Apr-08	May-08	Jun-08
2	CustomerA	X	Emerging	90	20	30	40
3	CustomerB	Y	New	160	30	10	120
4	CustomerC	X	Emerging	108	10	20	78
5	CustomerD	Y	Emerging	184	80	50	54
6	CustomerE	X	New	203	90	90	23
7	CustomerF	Z	Large	265	100	150	15
8
9	ComparenoofoccurencesofXwithnumberofoccurrenceofEmerging
10	SumthenumbersinEcorrespondingtothiscombination
11
12	Result	Emerging	New
13	X	198	203
14	Y	184	160
Sheet1

 

[ravishankar]

Hi
Try
=SUMPRODUCT(--(C2:C7="x"),--(D2:D7="Emerging"),e2:e7) change parameters to suit your query.
Ravi<!-- / message -->

 

[tinkletron]

Thank you, Ravi. It worked.