UnitedSkysJoey
New Member
- Joined
- Mar 3, 2017
- Messages
- 6
Hello Mr. Excel community!
I am at a lose.
I have this formula in one workbook and it works flawlessly. I am trying to add it to another workbook with the appropriate changes. But I am not getting the desired result. I am hoping that someone who hasn't stared at the workbook for endless hours can spot my mistake.
I have one sheet that has a date in a cell (I16) that is being referenced in the formula.
I have another sheet that has many rows of data. The header rows are dates.
I want this formula to return the value of the cells that have headers with the same year.
=SUM(IF(YEAR('Skylights P&L'!1:1)=YEAR(I16),'Skylights P&L'!6:6,0))/1000
Instead of returning just those with the matching year it is returning the sum of the entire row.
Thanks in advance for the assistance.
I am at a lose.
I have this formula in one workbook and it works flawlessly. I am trying to add it to another workbook with the appropriate changes. But I am not getting the desired result. I am hoping that someone who hasn't stared at the workbook for endless hours can spot my mistake.
I have one sheet that has a date in a cell (I16) that is being referenced in the formula.
I have another sheet that has many rows of data. The header rows are dates.
I want this formula to return the value of the cells that have headers with the same year.
=SUM(IF(YEAR('Skylights P&L'!1:1)=YEAR(I16),'Skylights P&L'!6:6,0))/1000
Instead of returning just those with the matching year it is returning the sum of the entire row.
Thanks in advance for the assistance.