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...
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...
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...
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...