Well, that is odd. Im uploading again ... What about this link? https://drive.google.com/file/d/1-9vnC9UAoffLdXcVDTTN6oIJ8UJO041w/view?usp=sharing -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005
On Mon, Oct 10, 2022 at 6:37 PM Steve Edmonds <[email protected]> wrote: > > At that link I get no download option and a message that the file is in > your trash. > Steve > > On 11/10/2022 12:27, Wade Smart wrote: > > https://drive.google.com/file/d/1Q4Skv003T-puY-2CBr-MMQHUVC-qBhfw/view?usp=sharing > > > > I thought I was making headway but just got myself into more of a problem. > > > > The link above is a sample of what Im working with. > > In this spread sheet I have hundreds of sections of this that are > > added to and updated. > > > > If you click on cell BG4 you'll see the IF hell function that I > > continually update (and fix). > > This is created by someone else and the IF statement doesnt account > > for all the things > > that are currently going on but - in general - Section One is B4 to > > I4. The entire colored > > space from B3 to I13 is the whole section. Each row is calculated by > > putting in 1 thru 4 under > > each item name, though at the moment, and the reason Im looking to do > > this [upgrade] is that > > 3 and 4 and the coming 5 are not being calculated. > > > > Row 4, B4 to I4 either a 1 or 2 is put in. J4 is the number of items. > > Cell BE4 totals all items from each section. > > > > Cell BG4 - currently the massive and incorrect IF statement - adds up > > each cell and calculates > > a number. In this example, F4 is BL SM and is a 1 so BG is 38. Each > > row can have a 1 thru 4 > > (upcoming 5) in each of the available cells. > > > > > > Looking at Row 7, Cell BG7 is the start of something I thought would > > work but... I got stuck. > > And, to be really honest, I got stuck writing this email for help > > because - I got lost in trying to > > explain this HAHA > > > > Looking at the function in BG7, check if its a number first and then > > look up the value of F3 item > > 1 in Sheet two which is 38. Cell BG8 does the same but shows the > > quickly growing IF statement > > for getting data for 2 cells. > > > > Question: does someone know of an easier way to do this without > > ongoing IF statements? > > > > Wade > > > > > > > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
