Help with Excel formula

[VMunsamy]

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)))

[#2]

@VMunsamy 

Your formula works correctly for 2 out of the 7 categories, but for the other 5 categories, there could be an issue with:

Data types in columns G, F, T, and U (numeric vs text). Ensure that contain consistent data types.

A mismatch in the range selection or filtering logic that could exclude relevant data.

A potential issue with empty cells in the range or hidden rows that aren’t being accounted for properly.

The SUBTOTAL function with 103 is used to count visible cells in filtered data.

=IF(SUBTOTAL(103, G11:G788) = COUNTA(G11:G788), "",

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

Formula is untested, backup your file first.

My answers are voluntary and without guarantee!

Hope this will help you.

[#3]

Thank you for the assistance, I'm not sure why it still does not work.

[#4]

@VMunsamy 

I realize this is probably information that is private or confidential, but it would be far easier to help if you would be willing to share either the actual spreadsheet or a copy that has been stripped of any identifiable names or account numbers, etc.

It's entirely possible that instead of the formula you're using, an altogether different method could be used to produce those summary blocks. But it is next to impossible to do other than guess without seeing how you've organized your master database(s).

A workbook may be attached to a reply here in the forum, or placed on OneDrive or GoogleDrive with a link pasted here that grants access.