looking for a formula for a worksheet

[Guest]

I have formulas in fields that are like this =IF(AND(EB7-C7<30,EB7<>""),"x","")
but I want it to use an E if a cell has an "X" and a D if a different cel
has an "X" but they need the current formula to work with these so at the end
of my worksheet I can tally how many E's and D's for each specific time
period. There are other columns with <60, <90, <180, etc.. These are used for
monthly statistical reports.

Thanks

 

[Bob Phillips]

Celeste,

Can you give an example of what the data looks like, where it is stored
etc., and what your expected result is?

--

HTH

RP
(remove nothere from the email address if mailing direct)