Good afternoon,
I'm in a bit of a predicament. I only have a basic understanding of the SUMPRODUCT formula to begin with and have been using it within this training tracker for a couple months. It's just come to my attention that on the "Attendance Reports" tab, the "Attended" will only count cells that have a number >0. I would like to figure out how to have it populate based upon the cell containing either 1) a percentage or 2) the letter "A". How would I format that into the formula? Thanks!
Here is the formula, workbook in question is attached with sensitive data redacted.
Please Login or Register to view this content.
Bookmarks