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.
This is a discussion on if condition is true, then sum within the Excel Questions forums, part of the Question Forums category; I have the following data in seperate columns: 2 M 5 C 3 C 3 C 4 M 2 M ...
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
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.
I can't get the formula to work. It keeps coming up with Zero
hi!
try this!
=sumif(b:B,"M",a:A)
where column B is the crietria and coumn A is the values
to sum up.
There is always a better way!!
******** ******************** ************************************************************************>
Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows Windows 2000
File Edit View Insert Options Tools Data Window Help About
=
A B C D E F 1 Num ID * * * * 2 2 M Count*What? M C B 3 5 C How*Many*instances*in*Col*B? 3 3 1 4 3 C Sum*of*values*in*Col*A 8 11 6 5 3 C * * * * 6 4 M * * * * 7 2 M * * * * 8 6 B * * * * 9 * * ID Data Total * 10 * * B Sum*of*Num 6 * 11 * * * Count*of*ID 1 * 12 * * C Sum*of*Num 11 * 13 * * * Count*of*ID 3 * 14 * * M Sum*of*Num 8 * 15 * * * Count*of*ID 3 * 16 * * Total*Sum*of*Num * 25 * 17 * * Total*Count*of*ID * 7 *
Sheet2 *
[HtmlMaker light Ver1.10] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
Like this thread? Share it with others