H E L P with retreiving data

  • Thread starter Thread starter David Joseph
  • Start date Start date
D

David Joseph

Need A Little help figuring this on out.

I need to establish a cell at the bottom of the run sheet page (example
attached) or B60 that says IF the drivers name for this example is Emily
THEN go to
each Emily on the drivers column I4:I20 and get that total charge which is
the last
figure to the right T$:T20 and then add the totals for Emily and enter that
total
into an Emily's cell box at the bottom somewhere on the run sheet, B60

Driver column has different drivers in it of course.

Copy of a run sheet example is attached.

(e-mail address removed)

Disabled American Veteran
James A Haley Veterans Hospital
Tampa, Florida

"Remember That The Price Of Freedom Is Not Ever FREE"
 
David
Thanks for making it possible for me to help you with this. And thanks
for making it so I do it in English.
Put this formula in any cell you want outside of the range of drivers
and charges. The formula is written with the drivers in I4:I20, the charges
in T4:T20, and the name of the driver for which you want the answer in H1.
You can change things as you need.
=SUMIF(I4:I20,H1,T4:T20)

HTH
Otto
Roswell, GA
 
Back
Top