Hey guys, this forum has been really great, and I posted my first question yesterday and they help was phenomenal. Today is part two of this big project I am working on and hopefully I can explain it clearly and get the same great help.
Today's problem has two worksheets "SBDATA" and "MTDATA" -- I will try to be as clear as I can. Both worksheets need the same results (from different columns) combine to a final summary page. These two worksheets cannot be combine for any reason at this time.
The results are appearing on a third worksheet currently labeled "SUMMARY" -- SO, this formula is currently going into cell "B4" on the "SUMMARY" page.
So, here we go!
On the "SBDATA" worksheet Column AH has a data range that starts at cell AH6 and goes down (changing in length each month) There are four potential outcomes in this column -- Leaf, Pear, Orange, and DMC --- I need to only identify the "Pears" in the range ---
IF it is a Pear, I am then moving cell D6 (again a range going down and changing in length each month) -- From here once I know the "Pears" I would like to verify if the "Pears" in this column (D6 and down) have the variable "I" in this colum.
Step 3 -- if it is a "Pear" in column AH and "I" in column D ----> next is to confirm if it is a "1" in column E (again starting from E6 and down)
Finally -- If it is a "Pear" in column AH and "I" in column D and "1 in column E ----> I then need to count all the "1"s in Column Q ---> This range again starts at Q6 and goes down and changing each month. All of these "1" must have a final count in cell "B4" on the "SUMMARY" page...
This is my more complex problems., and I know trying to type it is hard....
Please let me know if you can help !!!!
thanks
-rt
Bookmarks