Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Data in A1:B6 like you suggested.
Have the names for the totals in e.g. a8, a9 etc In B8 enter: =SUMIF($A$1:$A$6;"="&A8;$B$1:$B$6) Copy the formula down as required. If you want to remove blanks in your names create entries in C1:C6 and use this formula in C1 =SUBSTITUTE(A1;" ";"") copy down to C6 and base your sumif command on the new column like: =SUMIF($C$1:$C$6;"="&A8;$B$1:$B$6) Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Printing formulas | Excel Discussion (Misc queries) | |||
Formulas referencing other sheets | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |