View Single Post
 
Old 05-13-2011, 12:47 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Quote:
Originally Posted by ilkks View Post
Example Excel-sheet attached.

There should be ascending numbering at column E. How to make blank cell instead of space " "?

And 'Total price' should sum up every cell next to text "Price", but that formula is also failing.
Hi Ilkks
I am not sure if this is what you want but I have modified the formulae slightly. What will happen now is if you insert extra rows against each product the numbering will still run ascending.
If this is not what you want please provide more info and I will see what I can do.
Tony
Attached Files
File Type: xlsx Copy of ExcelSheet(1).xlsx (10.7 KB, 19 views)
Reply With Quote