Forum Discussion
Countif function
Looking at Sheet1 again:
how about you use cell D4 to figure out if step 2 has been achieved. If the scout needs to complete 4 out of 5 of the sub-tasks of task 2, then use
=IF(COUNTIF(D5:D9,"a")>=4,"a","p")
Similar in D12. If they need to achieve, say, 6 out of the 9 subtasks, use in D12:
=IF(COUNTIF(D13:D21,"a")>=6,"a","p")
Then, total the eight question results, but ignore the rows with the sub-tasks, because they have been rolled up into D4 and D12. So for "requirement 1 and 5 others" you could do
=IF(AND(D3="a",COUNTIF(D4,"a")+COUNTIF(D10:D12,"a")+COUNTIF(D22:D24,"a")>=5),"C","P")
Does that make sense?
Good Morning-
I have a question on how to combine the COUNTIF Function along with the SUMIFS function. I would like to take the total of approval letters which would be the "Y"s and add it to the sum of Denial letters for the nurse Cindy. Therefore, Cindy sent 1 approval letter and 3 denial letters which would be a total of 4 letters. How would I write that in a formula?
I apologize in advance If i posted this message in the wrong place or used the wrong procedure, I am new to this procedure.
Hi Raquel,
Yes, that's a separate question, please start in new thread - go to Formulas and Functions here and click Start new conversaton button.
And please clarify for you question - you have few records for each nurse (e.g. for Cindy 1 approval + 3 denial; another record for her no approval + 1 denial). Would you like to calculate sum of approvals for all records or for each record separatelly.
In first case for Cindy it'll be 1+3+0+1 = 5 total letters.
My mistake, I meant that Cindy would have a total of 5 letters. Sorry for the typo
As a variant you could use in D2
=SUMIF($A$2:$A$70,A2,$C$2:$C$70)+COUNTIFS($A$2:$A$70,A2,$B$2:$B$70,"Y")
and drag down then
- thank you I started a new conversation as you requested.
Okay, i see
