SUM of a column if [factor1] and [factor2] and [factor3]

brianne111081 · 11/13/19

I am trying to calculate the sum of mcqs (# MCQs) for the course ID (Course) if they were contracted in November (Contracted Date) and the Completed box is NOT CHECKED (Completed).

Any help would be greatly appreciated!!

Paul Newcome · 11/13/19

Give something like this a try...

=SUMIFS([# MCQs]:[# MCQs], Course:Course, "ID", [Contracted Date]:[Contracted Date], AND(IFERROR(MONTH(@cell), 0) = 11, IFERROR(YEAR(@cell), 0) = 2019), Completed:Completed, 0)

SUM of a column if [factor1] and [factor2] and [factor3]

Comments

Categories