Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
May be a long-shot, but.....
Hello all. For the life of me, I can't get my sum functions to work
with text entries. FTR, I am using Excel 2003. The purpose lays in this example... I have a column with three different alpha-codes that have been designated like this: A denotes blue textbooks B denotes brown textbooks C denotes red textbooks In this column, there are 45 rows with either an A, B or C classification. Is it possible to add a function/formula where I can automatically calculate a subtotal of each, then a grand-total of all classifications together? I know this is a weird request, but I have been out of the function loop far too long, and I am certainly not a coder, by any means. Thanks in advance for your great help! Chris |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
May be a long-shot, but.....
Use the sumproduct function:
http://www.contextures.com/xlFunctions01.html http://www.xldynamic.com/source/xld.SUMPRODUCT.html Alternatively, use a Pivot Table: http://peltiertech.com/Excel/Pivots/pivottables.htm Regards, Ryan--- -- RyGuy " wrote: Hello all. For the life of me, I can't get my sum functions to work with text entries. FTR, I am using Excel 2003. The purpose lays in this example... I have a column with three different alpha-codes that have been designated like this: A denotes blue textbooks B denotes brown textbooks C denotes red textbooks In this column, there are 45 rows with either an A, B or C classification. Is it possible to add a function/formula where I can automatically calculate a subtotal of each, then a grand-total of all classifications together? I know this is a weird request, but I have been out of the function loop far too long, and I am certainly not a coder, by any means. Thanks in advance for your great help! Chris |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
May be a long-shot, but.....
Try one of these:
=COUNTIF(A1:A45,"A") =COUNTIF(A1:A45,"B") =COUNTIF(A1:A45,"C") C1 = A C2 = B C3 = C Enter this formula in D1 and copy down to D3: =COUNTIF(A$1:A$45,C1) For the grand total: =SUM(D1:D3) -- Biff Microsoft Excel MVP wrote in message ... Hello all. For the life of me, I can't get my sum functions to work with text entries. FTR, I am using Excel 2003. The purpose lays in this example... I have a column with three different alpha-codes that have been designated like this: A denotes blue textbooks B denotes brown textbooks C denotes red textbooks In this column, there are 45 rows with either an A, B or C classification. Is it possible to add a function/formula where I can automatically calculate a subtotal of each, then a grand-total of all classifications together? I know this is a weird request, but I have been out of the function loop far too long, and I am certainly not a coder, by any means. Thanks in advance for your great help! Chris |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
May be a long-shot, but.....
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shot down with blanks | Excel Worksheet Functions | |||
O/T I know this may get me shot.......... | Excel Discussion (Misc queries) | |||
A shot in the dark | New Users to Excel | |||
Print a screen shot in Excel? | Excel Discussion (Misc queries) | |||
Print a screen shot in Excel? | Excel Discussion (Misc queries) |