I am in need on assitantce.
It has been a long time since I've worked with Excel spreadsheets and formulas. I need to work on a spreadhsheet that was changed. All data was kept in one sheet. Now the data needs to be kept in two separate sheets IN the SAME workbook.
There are different areas in the worksheet with fomulas. All of them pretty much look at data that is coming from a worksheet called WHC Data so basically the formula with be in the second worksheet showing whatever informaiton is containt in the the first sheet.
=SUMPRODUCT(($C$27:$C$505="Dr. Ray")*($O$24:$O$505="Not Healed (next column)"))+SUMPRODUCT(($C$27:$C$505="Dr. Ray")*($O$24:$O$505="Healed"))
I can't remember how to look at data in other worksheets. If I can make this work I should be able to modify the rest of the fomulas.
Edited by boopme, 13 July 2009 - 08:55 PM.