Hello,
I am fairly new to excel and formulas and am trying to learnt he best i can
I am a bit stuck on a formula which I can't seem to work out...
I have a spreadsheet of invoices we have sent out to our customers for each pay period, I have a tab for each pay period with a list of names in one column (Column F), a list of amounts of what that customer owes us in another column (Column H), and then a final column which i have done with conditional formatting, which highlights any customer who hasnt paid yet, if the box is blank (Column I).
I then have another tab which is a summary sheet, where i want to find out how much that person has outstanding for all of the pay periods.
The current formula i have been trying is this one:
=SUMPRODUCT(SUMIFS(INDIRECT("'"&sheets&"'!"&"$F$166:$F$1000"),$B7,INDIRECT("'"&sheets&"'!"&"$I$166:$I$1000"),"",INDIRECT("'"&sheets&"'!"&"$H$166:$H$1000")))
Can someone please point out where i am going wrong, and help me if possible, as i have been going round and round in circles trying to figure out why its not working, and feel like i am missing the obvious
I am fairly new to excel and formulas and am trying to learnt he best i can

I am a bit stuck on a formula which I can't seem to work out...
I have a spreadsheet of invoices we have sent out to our customers for each pay period, I have a tab for each pay period with a list of names in one column (Column F), a list of amounts of what that customer owes us in another column (Column H), and then a final column which i have done with conditional formatting, which highlights any customer who hasnt paid yet, if the box is blank (Column I).
I then have another tab which is a summary sheet, where i want to find out how much that person has outstanding for all of the pay periods.
The current formula i have been trying is this one:
=SUMPRODUCT(SUMIFS(INDIRECT("'"&sheets&"'!"&"$F$166:$F$1000"),$B7,INDIRECT("'"&sheets&"'!"&"$I$166:$I$1000"),"",INDIRECT("'"&sheets&"'!"&"$H$166:$H$1000")))
Can someone please point out where i am going wrong, and help me if possible, as i have been going round and round in circles trying to figure out why its not working, and feel like i am missing the obvious
