if condition is true, then sum

[CHRISMAZUR]

I have the following data in seperate columns:

2 M
5 C
3 C
3 C
4 M
2 M
6 B

I want ot know how many M's, C's , and B's are there
M=
C=
B=

How do write a formula that will add all the numbers that are M's, C's and B's

 

[PaddyD]

hi - welcome to the board!

reivew the help files for the sumif() & countif() functions. also check out pivot tables. post back if you need more.

 

[CHRISMAZUR]

I can't get the formula to work. It keeps coming up with Zero

 

[SIXTH SENSE]

hi!
try this!
=sumif(b:B,"M",a:A)
where column B is the crietria and coumn A is the values
to sum up.

 

[PaddyD]

Book1
	A	B	C	D	E	F
1	Num	ID
2	2	M	CountWhat?	M	C	B
3	5	C	HowManyinstancesinColB?	3	3	1
4	3	C	SumofvaluesinColA	8	11	6
5	3	C
6	4	M
7	2	M
8	6	B
9			ID	Data	Total
10			B	SumofNum	6
11				CountofID	1
12			C	SumofNum	11
13				CountofID	3
14			M	SumofNum	8
15				CountofID	3
16			TotalSumofNum		25
17			TotalCountofID		7
Sheet2