Calculate a range of $ based on cumulative reference # from another column - Excel 2003

Scenario is. I have a $ amount in one column that I need to obtain a cumulative total on based on reference information from another column. EXAMPLE:

Column G - Transaction Amount; Column H - G/L Account; Column I - WO #.

Column G will have rows of transaction amounts that are then referenced by the G/L Account in column H and further broken down by the WO # in Column I.

What I need is a formula that sums all the $ amounts for each individual G/L account and then again by each work order.

G / H / I
Transaction Amount / G-L Account / W-O #
$25.55 / 1460-0001 / 783
$2568.99 / 1460-0001 / 794
35.96 / 3500-0000 / 775
2500.86 / 3500-0000 / 775
29.89 / 1460-0001 / 783

Need result to read in separate columns (because the info is then linked to other sources) -
1460-0001 / 783 / 55.44
1460-0001 / 794 / 2568.99
3500-0000 / 775 / 2536.82

Try this, copied down...

=IF(C85="",SUMIF($B$3:$B$83,B85,$A$3:$A$83),SUMIFS($A$3:$A$83,$B$3:$B$83,B85,$C$3:$C$83,C85))

If you only want to sum by account, use...
=SUMIF($B$3:$B$83,B85,$A$3:$A$83)
or is you only want to sum by WO, change the B ref to C

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)