Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Excel Help


bryan275

Recommended Posts

I have a spreadsheet that tracks various projects listed down rows. Against these projects i have Profit and loss lines some repeated as different projects can affect the same p and L line. I need to code up a page behind it that will remove the repeated PNL lines per project and sum them up, so that we have Project group, PNL Line and value of that PnL line (total of the various vertical cells all one after the other). Any help will be much appreciated.

 

 

Example heading

Project group, Project title, PnL Line, Amount

a ba CoS X

b ab payroll 2X

c ac CoS 5x

a ba CoS X

a ba CoS X

 

I need to group the projects into one line offering the group, PnL and amount, so that project group a for example ends up as a total for that respective line...

 

Please help...

Link to comment
Share on other sites

where is this having to do with osCommerce database tables?

if for profit/loss on products, use an accounting pagkage, which has these kinds of things built in.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...