Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum formula needed
I need a sum formula for the following. in the first column is the
letters and the second is the reason. at the bottom i would like a total of how many "A's" there were B's, C's etc. So if i type the letter C in the right column it would add one to the total and make it 5. Here is a link to the example. any help would be great. thanks A = 4 B = 2 C = 4 http://img401.imageshack.us/img401/5587/codebg0.jpg |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum formula needed
try countif. =countif(a1:a100,"a")
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Zilla" wrote: I need a sum formula for the following. in the first column is the letters and the second is the reason. at the bottom i would like a total of how many "A's" there were B's, C's etc. So if i type the letter C in the right column it would add one to the total and make it 5. Here is a link to the example. any help would be great. thanks A = 4 B = 2 C = 4 http://img401.imageshack.us/img401/5587/codebg0.jpg |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum formula needed
On Feb 27, 2:56 pm, john wrote:
try countif. =countif(a1:a100,"a") -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Zilla" wrote: I need a sum formula for the following. in the first column is the letters and the second is the reason. at the bottom i would like a total of how many "A's" there were B's, C's etc. So if i type the letter C in the right column it would add one to the total and make it 5. Here is a link to the example. any help would be great. thanks A = 4 B = 2 C = 4 http://img401.imageshack.us/img401/5587/codebg0.jpg that works great thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula needed | Excel Worksheet Functions | |||
Formula help needed | Excel Worksheet Functions | |||
Formula Help Needed | Excel Worksheet Functions | |||
Formula Needed | Excel Discussion (Misc queries) | |||
Formula Set Up Needed | Charts and Charting in Excel |