I'm so thankful for all of the help that I've received on this site. I'm hopeful that someone can figure this one out for me. I don't even know if it's possible with how it's set up in this book. I've attached a small example.
Two sheets. I need help with the cells I colored blue in the Community List sheet.
In All Data sheet, E:I adds up the cells to the right, by their value. E2 is a total of J2 and O2; it shows us how many 5's we got in Jan 2013.
I need to get that data into the format on the Community List sheet. C2 on Community List is good to go. But I want to be able to drag this formula over and down, making sure that for D2 on Community List it pulls the data from All Data F2 and so on.example3.xlsx
Bookmarks