| Home > Forum Home > Analyzing Corporate Financial Data > Making totals | Share |
Making totals
Excel Help for Making Totals in Analyzing Corporate Financial Data
| Forum Topic | Post Reply Login |
Making Totals | Rate this: (3/5 from 1 vote) |
 | Hello guys... im quite new in Excel... well i need some help... i have made just a sample what ive got and what i need :)... ive uploaded a file to here http://shokarta.kabel1.cz/schedule.xls on LIST1 is wht ive got already, and then i need to make any total like on LIST2... make some macro or whatever what would make a name on the top, then the number and amounts... and then just totals.... and do it for every name on the LIST1... i guess thats not as difficult to do that for anybody who knows what to do :)... im hopeless because ive got like hunderts of names and numbers units etc, and counting it manualy is a nightmare.... thanks guys for understanding | |
| Shokarta | ||
| Posted by Shokarta on | ||
| Replies - Displaying 1 to 1 of 1 | Order Replies By: Most Recent | Chronological | Highest Rated |
| Rate this: (3/5 from 1 vote) do not type copy from list 1 so that no spelling mistake occurs. in D2 type this formula =SUMPRODUCT((List1!$C$2:$C$34=D1)*(ROUND(List1!$B$2:$B$34,0))) note the dollar signs. copy D2 to E2,F2 and G2. is it ok? post feedback |
| Posted by [email protected] on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for Making totals in the Excel Business Solutions Directory |