Formula for addition
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
|