Customized Sum
For every row in Cols B and C, I'd like to multiply the values and sum it at the top of Col C. I'm trying not to insert an extra column, so I stick to one column per student. Is this possible ? Thank You Mike |
Customized Sum
Check out the SUMPRODUCT function - as I understand your description, it should do what you want. -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113142 |
Customized Sum
Thank You I had tried it; just needed to work on my syntax MK "jamescox" wrote: Check out the SUMPRODUCT function - as I understand your description, it should do what you want. -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113142 |
All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com