ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Customized Sum (https://www.excelbanter.com/excel-programming/430762-customized-sum.html)

lab-guy

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

jamescox[_89_]

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


lab-guy

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