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 TopicLogin

Making Totals

Rate this:
(3/5 from 1 vote)
Confusedin 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 on
 
View Full Post

Find relevant Excel templates and add-ins for making totals in the