I did try the pivot option to bring in the subtotals and that worked, but i still ran into the issue of trying to work the calculation into the pivot.
When i did the calculation in the pivot, it only worked correctly for the 'subtotals' and not the other cells.
Can you expand on any...
What ive done is pulled a report from our database and ive applied a subtotal to columns A-D.
Column E, only on the sub total line for each change in value in column A is just a simple division.
What i want is the proceeding cells in column to be auto filled with the formula = $E$7 * D6...
Hey Guys
I have an issue which is bugging me and something i dont want to do manually.
In the attached document, i need the bolded subtotal in column E to be multiplied by the pertinent cells in column D i.e. cell E7 is 194.94 * D2 = 194.94, cell E7 is 194.94 * D3 = 194.94 and so on.
My...
Thanks Dan, appreciate the extended answer.
One final thing. Ive recreated the book using your steps and ive gotten this to work, however the color coding is the typical red and blue that excel defaults on. For above 80 im getting the red, below 80 im receiving the blue.
In your examples, it...
Thanks for your reply Dan, this is exactly what i was after.
Is it possible for you to explain in greater depth for my knowlegde the use of the if/then and the dynamic ranges?
I want to use this in future and apply it to various sheets, so id like to brush up on the theory behind the actual...
Hi Guys
I want to conditional format a bar graph based on the results within B3-B14. Ive applied a conditional format to B3-B14, in which anything equal or greater than 80 is green and anything less than 80 as red.
Essentially i want the graph results for that given month to replicate the...