How find the sum of rows in columns with criteria?

[mtbthepro]

Hello,
I have a workbook with departments and some of these departments have a grand total without the grand total. The table looks like this...

[TABLE="width: 986"]
<tbody>[TR]
[TD="colspan: 3"]Department 58 Aqua Rec all unitspools[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]ACCOUNT#: 1-026-58-00000-3343[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MEMBER NUMBER[/TD]
[TD]MEMBER NAME[/TD]
[TD]TRN DATE[/TD]
[TD]0 -30 DAYS[/TD]
[TD]31-60 DAYS[/TD]
[TD]61-90 DAYS[/TD]
[TD]OVER 90 DAYS[/TD]
[TD]PAST DUE[/TD]
[/TR]
[TR]
[TD]026-000176687-02[/TD]
[TD]Baptiste, Braylin[/TD]
[TD="align: right"]2/12/2017[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$209.00[/TD]
[TD="align: right"]$209.00[/TD]
[/TR]
[TR]
[TD]026-000160653-02[/TD]
[TD]Tracey, Noah[/TD]
[TD="align: right"]12/18/2016[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$209.00[/TD]
[TD="align: right"]$209.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ACCOUNT TOTAL[/TD]
[TD][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$418.00[/TD]
[TD="align: right"]$418.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]ACCOUNT#: 1-026-58-00000-3344[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MEMBER NUMBER[/TD]
[TD]MEMBER NAME[/TD]
[TD]TRN DATE[/TD]
[TD]0-30 DAYS[/TD]
[TD]31-60 DAYS[/TD]
[TD]61-90 DAYS[/TD]
[TD]OVER 90 DAYS[/TD]
[TD]PAST DUE[/TD]
[/TR]
[TR]
[TD]026-000178283-02[/TD]
[TD]Piechowiak, Eliza[/TD]
[TD="align: right"]2/19/2017[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$280.00[/TD]
[TD="align: right"]$280.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ACCOUNT TOTAL[/TD]
[TD][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$280.00[/TD]
[TD="align: right"]$280.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]GRAND TOTAL

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there a way to sum all the account totals into a grand total for all sheets?
Grand total are always in column C
Account totals are always in column B

 

[Special-K99]

Maybe SUMIF(D1:D1000,B1:B1000,"ACCOUNT TOTAL") for 0-30 DAYS column
and copy along the row for required number of columns

 

[mtbthepro]

Maybe SUMIF(D1:D1000,B1:B1000,"ACCOUNT TOTAL") for 0-30 DAYS column
and copy along the row for required number of columns

Can you please explain how each part of this code and how it works? I am not a pro at coding.

[COLOR=#333333]SUMIF(D1:D1000,B1:B1000,"ACCOUNT TOTAL")[/COLOR]

 

[Special-K99]

https://support.office.com/en-gb/ar...1697a653039b?ui=en-US&rs=en-GB&ad=GB&fromAR=1