SUMIF across multiple worksheet

[NFIAu]

Hi,

I'm trying to set up a budget tracker which could be for up to 10 various programs.

Each worksheet has the below information with a list for the service such as DATS (there are also MH & AH). On the summary sheet I will have tables for each of DATS/MH/AH programs etc and want to pull the budget shown on the subsequent sheets if it relates to that program into the same layout as on each of the individual sheets.

[TABLE="width: 318"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]Service
[/TD]
[TD="colspan: 2"]DATS
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]Funding
[/TD]
[TD]OoS
[/TD]
[/TR]
[TR]
[TD]Budget
[/TD]
[TD]0
[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]Claimed
[/TD]
[TD]$0.00
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]Remaining
[/TD]
[TD]$0.00[/TD]
[TD]27
[/TD]
[/TR]
</tbody>[/TABLE]



Thanks so much to anyone who can help me stop pulling my hair out!!

 

[arthurbr]

Perhaps http://www.xl-central.com/sum-single-criteria-multiple-sheets.html