I get safety reports that need data mining, the format is a spreadsheet that is always 10 columns wide (A-J), but varies in length from 26 to 234 lines long, depending on the complexity of the safety audit. The next report is right below it, 5 empty lines separate them, the next report can also be anywhere between 26 and 234 lines long, kind of an endless list for each year of audits. What I need to do is add up how many "P" (pass) and "F" (fail) answers there are in column G. Since the range of reports varies, I cannot use a simple formula to Sum G2:G234 because it may grab information from one or several reports.
Is there some way to SUM only the G cells between two headers, or between two anything? It would be great to insert a beginning and end border of some kind, and just SUM the data between them, without having to build a formula for every report, and every edit that effects length. The reports come in varying order, different every day, we often have to tweak them. There are a lot of formulas and color formatting on these safety entries, so I cannot send them to a table, excel errors when I try.
The P & F data gets collected and sent to another sheet, that becomes a weekly report. I am manually counting the the data now.
I can post examples if needed. Thanks!!
Bookmarks