attachment
Please find the attached raw data and pivot table. I built a formula in cell B14 on the Hours by Title sheet. I want to use 'fill right' to apply the same formula across row 14. However, when I do, it continues to use 'count of clinicians' (or column B) in the formula instead of automatically using the next column over. This results in incorrectly showing the same result from B14, even if the values in column C or D should be generating a different result.
|