COUNTIFS Automatically pick up cell
I have built a worksheet using countifs to counts the number of transits ships make in and out of the port with 3 criteria. As we are monitoring across a 12 month period for compliance the workbook is working well.
One of the criteria is counting the Captain’s name (1 of 41 names). Is there a way to automate the formula to pick up the name rather than typing it 96 times for each person.
This is the COUNTIFS formula – The Name in this case is Starkey =COUNTIFS(June!$C$2:$C$638,”Night”,June!$F$2:$F$638,”Starkey”,June!$K$2:$K$638,”Inbound”,June!$M$2:$M$638,”Tory”)
I have built a worksheet using countifs to counts the number of transits ships make in and out of the port with 3 criteria. As we are monitoring across a 12 month period for compliance the workbook is working well. One of the criteria is counting the Captain’s name (1 of 41 names). Is there a way to automate the formula to pick up the name rather than typing it 96 times for each person.This is the COUNTIFS formula – The Name in this case is Starkey =COUNTIFS(June!$C$2:$C$638,”Night”,June!$F$2:$F$638,”Starkey”,June!$K$2:$K$638,”Inbound”,June!$M$2:$M$638,”Tory”) Read More
