| Home > Forum Home > Analyzing Corporate Financial Data > Making totals > making totals | Share |
Making totals
Excel Help for Making Totals in Analyzing Corporate Financial Data
| Forum Topic | Login |
Making Totals | Rate this: (3/5 from 1 vote) |
 | in list 2 in D1 type George, E1 Lucas, F1 Ronald, G1 Tim 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 | ||
| View Full Post |
| Find relevant Excel templates and add-ins for making totals in the Excel Business Solutions Directory |