I need some help with the following situation as I am currently having to manually update formulas which is adding about 13 hours onto my 45 hour work week.
Here's the scenario:
I'm creating a weighted average percentage that is taking data from two different pivot tables to calculate. Rather than manually updating cell formulas (based on if they are in my pivot or not b/c they go in and out), I would like to have a lookup based on a common name (which I have). However, when I was working on this, I can't get my lookup to sum rows across and return the appropriate value to me.
My current formula:
=IFERROR((SUM($B$7:G$7)/G$443)*$B$444"")/IFERROR((SUM($B$7:G$7)/G$443)*($B$444-1)+($B453),"")
Where the pink is coming from pivot tables and has a common naming convention; the orange is the day and the blue is the month.
How can I simplify this equation?
Here's the scenario:
I'm creating a weighted average percentage that is taking data from two different pivot tables to calculate. Rather than manually updating cell formulas (based on if they are in my pivot or not b/c they go in and out), I would like to have a lookup based on a common name (which I have). However, when I was working on this, I can't get my lookup to sum rows across and return the appropriate value to me.
My current formula:
=IFERROR((SUM($B$7:G$7)/G$443)*$B$444"")/IFERROR((SUM($B$7:G$7)/G$443)*($B$444-1)+($B453),"")
Where the pink is coming from pivot tables and has a common naming convention; the orange is the day and the blue is the month.
How can I simplify this equation?
