Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

Need Help with a Sum of a Product of a Currency and Product

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tbwhitworth@hotmail.com - 26 Sep 2007 20:23 GMT
Does anyone have a way to simplify this formula and make it so it
automatically includes newly added rows or cells?

=SUM((SUM($K$9:L9)*$H$9),(SUM($K$11:L11)*$H$11),(SUM($K$13:L13)*$H$13),
(SUM($K$15:L15)*$H$15),(SUM($K$17:L17)*$H$17),(SUM($K$19:L19)*$H$19),
(SUM($K$21:L21)*$H$21),(SUM($K$23:L23)*$H$23),(SUM($K$25:L25)*$H$25),
(SUM($K$27:L27)*$H$27),(SUM($K$29:L29)*$H$29),(SUM($K$31:L31)*$H$31),
(SUM($K$33:L33)*$H$33),(SUM($K$35:L35)*$H$35),(SUM($K$37:L37)*$H$37),
(SUM($K$39:L39)*$H$39),(SUM($K$41:L41)*$H$41),(SUM($K$43:L43)*$H$43),
(SUM($K$45:L45)*$H$45),(SUM($K$47:L47)*$H$47),(SUM($K$49:L49)*$H$49),
(SUM($K$51:L51)*$H$51),(SUM($K$53:L53)*$H$53),(SUM($K$55:L55)*$H$55),
(SUM($K$57:L57)*$H$57),(SUM($K$59:L59)*$H$59),(SUM($K$61:L61)*$H$61),
(SUM($K$63:L63)*$H$63),(SUM($K$65:L65)*$H$65),(SUM($K$67:L67)*$H$67))
Peo Sjoblom - 26 Sep 2007 20:49 GMT
One possible way

=SUMPRODUCT(((MOD(ROW(K9:L67),2)=1)*(K9:L67))*(MOD(ROW(H9:H67),2)=1)*(H9:H67))

Signature

Regards,

Peo Sjoblom

> Does anyone have a way to simplify this formula and make it so it
> automatically includes newly added rows or cells?
[quoted text clipped - 9 lines]
> (SUM($K$57:L57)*$H$57),(SUM($K$59:L59)*$H$59),(SUM($K$61:L61)*$H$61),
> (SUM($K$63:L63)*$H$63),(SUM($K$65:L65)*$H$65),(SUM($K$67:L67)*$H$67))

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.