Forum Discussion
Help with Excel formula
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.
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.
