i'm trying to write a formula in excel. ex: if cells A35 through A42 says "text" then the sum of the cell in column B in the same row as "text" plus the rest of the cells up to B35 (will be numbers) is entered into another cell. any help with this would be appreciated!!!Logic FUNCTIONS in Excel can be a pain. Here is a link that shows info on IF, THEN functions for Excel. http://office.microsoft.com/en-us/excel-help/if-HP005209118.aspx

I was creating a scheduling worksheet in which when plugging in who was available to work, it would populate the employees available into a schedule that could be printed out, but just when I thought i had all the logic correct, excel would malfunction and I didnt know why.

In the end, I ended up writing a program in C++ that did this logic far easier than in Excel and created a CSV file output. This CSV file I was then able to open with Excel and PRINT with the formatting of the schedule.

Best of luck in getting this to work. This is where I looked for info when I had to deal with IF, Then logic functions with Excel. Its not a lot of fun and as I stated above, it can malfunction and you are then looking for what logic routine is making it malfunction as a needle in the hay stack. So if you know how to program in any languages that can create COMMA delimited file output as a CSV, and then import that to Excel, that may be easier for you as it was for me. However if you are not fluent in any computer languages to achieve this, then your stuck with having to learn to do this all in excel which is a headache.

My schedule was for 32 employees populating 32 positions 24 hours a day on 3 shifts, for 7 days of the week. And with people on vacation, out on other leave etc, holes in the schedule had logic to get plugged with overtime, but what started off as a simple spreadsheet soon became overly complicated with logic that was all nested on itself for various conditions and for situations where more than 1 employee could plug a hole in the schedule Excel wouldnt rotate among those who are available to work overtime and so I had one guy given 20 hours of overtime while others were getting none and with union contract etc, I had to make sure that the overtime was fair and equal opportunity etc. After 2 days of trying to get this to work with Excel, I threw the towel in on it and dove into C++ coding which is my strength and the logic is so much easier to follow as well as keeping track of who is next in rotation for overtime also worked out far easier with C++ logic.Thank you for your input. I THINK I have it figured out (probably the hard way). I have to create 3 seperate tables off to the SIDE of the sheet to be hidden. One to calculate total lengths, another with ex: =IF(A35="text",C35), IF (A35 <>"text","0"). And the third for the outcomes of the if,then statements. Then the SUM formula to calculate the total of the outcomes in the cell I need to show that value.Yes, this is what I had to do as well to hide the logic off to the side, and the logic condition of other cells were based on the condition of cells earlier on the tree of logic such as Y3's condition fead Y4 and then Y4 fead Y5 in a IF THEN tree of logic, which the output of say Y5 passed the value into B8's formula where there is a calculation from the value of Y5.

For just a few of these its not very hard to follow, but the more conditions that are added, the bigger of a burden it is to keep track of the logic. Also you can get trapped in a which comes first chicken or egg calculations and then are trying to find a work around.

Glad you were able to get it working.