Hi 

I wanted to know if someone could help me with my excel spreadsheet. 

I have an annual spreadsheet linked to a master sheet in one workbook. 

Each sheet and the master sheet have a summary block at the top. 

The summary block reflects 7 categories, 

My formula below works correctly when I filiter for 2 out of the 7 categories. Im unsure why my other 5 other categories won’t calculate although I insert the correct block and line references. Can someone please help me ? 

=IF(SUBTOTAL(103, G11:G788) = COUNTA(G11:G788), “”, SUMPRODUCT((SUBTOTAL(103, OFFSET(G11, ROW(G11:G788)-ROW(G11), 0))=1) * (G11:G788 * T11:T788 + F11:F788 * U11:U788)))

​Hi I wanted to know if someone could help me with my excel spreadsheet. I have an annual spreadsheet linked to a master sheet in one workbook. Each sheet and the master sheet have a summary block at the top.  The summary block reflects 7 categories, My formula below works correctly when I filiter for 2 out of the 7 categories. Im unsure why my other 5 other categories won’t calculate although I insert the correct block and line references. Can someone please help me ? =IF(SUBTOTAL(103, G11:G788) = COUNTA(G11:G788), “”, SUMPRODUCT((SUBTOTAL(103, OFFSET(G11, ROW(G11:G788)-ROW(G11), 0))=1) * (G11:G788 * T11:T788 + F11:F788 * U11:U788)))   Read More

​