Database Sum Question

[MrvinGover]

I have a wrksheet that I fill out, one column has the amount spent and
the second has the GL code associated with that. I would like at the
end of the page to show a sum of the amount spent in each GL code.

(I.e.)

Vendor Invoice Amount GL Code
Bob 20.00 153110
sue 50.00 153114
sally 17.00 153110


totals
gl code amount
153110 37.00
153114 50.00

any assistance would be greatly appreciated

Don

 

[Aladin Akyurek]

Have a look at SumIf function.

 

[MrvinGover]

Thanks,

Here is my formula, i am having problems with the criteria section of
the sumif formula.

"=SUMIF(F9:F111,"=F117",E9:E111)"

i want the criteria to be dynamic by entering in the GL code into a
field and then populating the amount desired for look up. Does the
sumif formula allow for the criteria to be dynamic?

 

[Biff]

Hi Mrvingover,

Try it this way:

=SUMIF(F9:F111,F117,E9:E111)

Biff

 

[MrvinGover]

Thanks, that worked great