If I have the followings table
A B
1 Code Amt
2 501 70
3 500 85
4 501 75
5 502 50
6 500 55
7 501 10
8
How do I set the formula to add the total amount for code 501in say cell B8?

Thanks

Try this:

B8: =SUMIF(A2:A7,"501",B2:B7)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"tigermoth" wrote in message
...
If I have the followings table
A B
1 Code Amt
2 501 70
3 500 85
4 501 75
5 502 50
6 500 55
7 501 10
8
How do I set the formula to add the total amount for code 501in say cell
B8?

Thanks

Or without the quotes if the 501 is a number, not a text string.
--
David Biddulph

"Ron Coderre" wrote in message
...
Try this:

B8: =SUMIF(A2:A7,"501",B2:B7)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"tigermoth" wrote in message
...
If I have the followings table
A B
1 Code Amt
2 501 70
3 500 85
4 501 75
5 502 50
6 500 55
7 501 10
8
How do I set the formula to add the total amount for code 501in say cell
B8?

Thanks

Actually, regarding numbers (501) and numeric text ("501")..
Both of these SUMIF formulas pick up 501 and "501":
B8: =SUMIF(A2:A7,501,B2:B7)
B8: =SUMIF(A2:A7,"501",B2:B7)

....and would return 155 using the sample data.

So, in that particular case, the quotes in the criteria were unnecessary.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Or without the quotes if the 501 is a number, not a text string.
--
David Biddulph

"Ron Coderre" wrote in message
...
Try this:

B8: =SUMIF(A2:A7,"501",B2:B7)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"tigermoth" wrote in message
...
If I have the followings table
A B
1 Code Amt
2 501 70
3 500 85
4 501 75
5 502 50
6 500 55
7 501 10
8
How do I set the formula to add the total amount for code 501in say cell
B8?

Thanks