I have a spreadsheet listing my project managers names in column A, their
project titles in column B, what time they were submitted in column C, and an
IF function in column D telling me '1' for projects turned in on time, and
'0' for projects turned in late. Off to the side I have the names listed
again in one row, where i plan to show the total ON TIME projects under the
corresponding manager's name. In other words, I am trying to get a total
count, BY NAME, of only the projects turned in on time. I was thinking I
needed to nest an IF function inside a SUM or COUNTIF function but am unable
to get the outcome Im looking for. Any ideas?? Thank you