Please see attached.
As you find in the summary (Column S) I am trying to figure out a way to do a count and average in Columns (E,G,I,K,M,O,Q) based on Column A. In other words for 1-Count, Count all values in Columns (E,G,I,K,M,O,Q) where Column A equals 1 and same goes for Average.
Dates are used for something else, ignore dates for these calculations.
The values in the summary are correct and what I am trying to achieve automatically.
Thanks so much in advance.
Bookmarks