After working on this for far too long last night I woke up to see responses here. I def appreciate it - esp the examples sent directly. This turned out to be one of those - you dont know what you dont know until apply something and find - there are other hidden things you dont know about HAHA
Changing the sheet layout for hidden columns, etc turned out to be a real issue. What I ended up doing was: If - this and this are true, get this number * this other value and add it to the total. That was added to another horrible long formula that I didnt create .. so I had to be careful and not mess things up. Doing this type of checking to make sure both values were there - because if the lb was either empty or just completely not there - it really screwed things up. Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ Privacy Policy: http://www.documentfoundation.org/privacy
