Formula

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I would like to have a formula that has several if
statements in it and give me a dollar amount for the date
and code that i specify. for example i have a spread
sheet set up as follows
date reason code cost
6/22/04 we $1.00
6/22/04 be $1.00
6/22/04 msg $1.00

i need it to search for a specific date then search for
the 3 reason codes i have listed the give me the total
dollar amount for that date and reason codes.

i have been stuggling to figure out the formula that can
capture this information for me. any help would be
greatly appreciated.

thank you for your help
 
no i haven't considered a pivot table. the problem i have
is this is a report that i get daily and i have to sift
through a months worth of data to get my dollar figures.
can a pivot table be used in this case and work?
 
Tom said:
no i haven't considered a pivot table. the problem i have
is this is a report that i get daily and i have to sift
through a months worth of data to get my dollar figures.
can a pivot table be used in this case and work?
Click to expand...

Certainly - you can update your source daily and refresh the PT.
 
Back
Top