Search results

Agreed but using named ranges solves that problem.

Thank you for a streamlined, non-complicated approach that makes sense and works perfectly, Peter.

I have a worksheet with multiple percentages and coordinating description columns. On worksheets with a set of columns, I can use the formula =AVERAGEIFS(C:C,D:D,"<>Not needed"). However, I need to calculate multiple columns -- shown on the attached worksheet with the same status exclusion. I...

Thank you so much! I knew that I needed to move the first parenthetical mark but I just could not see it! Appreciate your help so much.

I have a cell showing net change -- both numerical and percentage. When positive, it has worked seamlessly, but I have negatives and I cannot find an answer. Basically, the net change is linked to two other calculated cells and an example is +30 (+6.3%) but when the answers are -55 (-10.6%) only...

I'll attach what I had before your answer. I am sorry I neglected to upload with my request.

Thank you, Peter! I needed to use the entire date so I ended up using the YEARFRAC function. I appreciate your help!

A friend has 10 "loans" that will need to be paid back (if he leaves the company) in full the first year, 80% the second year, 60% after three years, 40% after four years, 20% after five years, and 0 after six years. Easy for one date and amount. However, he has roughly ten dates with different...

Thank you!

I am not certain but I will take the blame. I do admit that I was exhausted after having worked on the worksheet for hours.

I love that Excel is logical and that human error is usually the problem. I do not know how to close this question, but I want to thank those who responded. I appreciate your clear thinking and patience.

Thank you, for another prompt response. There were a few cells not included by mistake (but are included on my original sheet.) I am beginning to think my file is corrupt because the file you sent back is working (I get 1455.2 when I select all the appropriate cells to be included.)

Thank you for the response, Hui. I know the totals are incorrect because I checked them after comparing to my accounting department's report totals. The cells I have excluded are included in the subgroup totals. If you hold the CTRL key and click the second row of each "group" (shaded or...

Thank you, AliGW. If you hold the CTRL key and click the second row of each "group" (shaded or non-shaded) and DO NOT INCLUDE the TOTAL SUBGROUPS rows, you will get 1839. I failed to highlight the BUDGET row (row 3) as all of those totals are incorrect as well. As I stated to vletm, the correct...

Thank you for your reply. When I highlight each of the cells referenced in C4's formula, I get a different answer (1455.2.) Actually, row 3 is not totaling correctly, either, as C3 should be 1637.0 rather than 1095.0. I learned about the problem when comparing the total from an accounting...

Thank you all for your replies. I am attaching a copy of the sheet. I have highlighted the cells that are giving incorrect totals. You will notice there are three subgroup totals and only the total row in those groups is included in the top total. To be honest, I have not tried a formula that...

I have a few cells where the sum calculation is not working correctly. When I highlight the cells, the total (sum) in the status bar is correct, however, the cell with the formula in it does not give an accurate answer (sum.) Please help! I have verified that cells involved are formatted as numbers

Oh, my word, vletm. Sometimes I overthink these formulas. I realize why no one offered to help right away when the answer is so simple! Thank you so much for your time and patience.

Hi vletm, I think that Column L should take the total of the last 12 numbers in column H and divide it by the average of the last 12 numbers in column D.

Anyone? I am stumped...and I am not an advanced Excel user. I appreciate any help!

Having trouble with a formula to calculate the 12-month rolling turnover rate for four categories. Missing some information so I am assuming I need to start formula in the 12th row of data? I've done this type of formula before but it only involved one column of data. Thank you for your help.

Thank you so very much, John! It worked perfectly!

This seems like a simple formula but I did not find another post addressing it. I wish to shade a row based on "CAST" within other text in the first cell of the row. =$B2="CAST" works if it is the only word, but there is a string of text in the cells of the first column. Thank you.

Thank you, p45cal. I really like the fact that your solution only displays YTD information!

Thank you, vletm. I was overthinking it and appreciate the simple formula suggestion. It works very well.