Database Sum Question

  • Thread starter Thread starter MrvinGover
  • Start date Start date
M

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
 
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?
 
Back
Top