See attached:
I would like to count the number of occurrances in Column D when Column A has the same value AND Column C = "Complete".
How would I write this formula?
There are no duplicate values in Column D.
See attached:
I would like to count the number of occurrances in Column D when Column A has the same value AND Column C = "Complete".
How would I write this formula?
There are no duplicate values in Column D.
This:
=COUNTIFS(A:A,A2,C:C,"Complete")
will do that for you.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Please try at E2
=COUNTIFS($A$2:$A$12,A2,$C$2:$C$12,"complete")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks