Hello,
I have 3 worksheets called Doe, Jones and Smith...I am keeping track of the number of meetings each person attends...
I'd like to count the number of "Presents" across 3 worksheets for January's meeting...
So I tried COUNTIF(Doe:Smith!B3,"PRESENT") But I got a value error.....Where is the error?
I am having trouble finding the error...
<colgroup><col width="125" style="width: 94pt; mso-width-source: userset; mso-width-alt: 4571;">
<col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;">
<col width="64" style="width: 48pt;" span="4">
<col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;">
<tbody>
</tbody>
I have 3 worksheets called Doe, Jones and Smith...I am keeping track of the number of meetings each person attends...
I'd like to count the number of "Presents" across 3 worksheets for January's meeting...
So I tried COUNTIF(Doe:Smith!B3,"PRESENT") But I got a value error.....Where is the error?
I am having trouble finding the error...
B | C | |||||
MEETING DATE | 1/7/2019 | 2/4/2019 | ROW 2 | |||
ATTENDANCE | PRESENT | PRESENT | ROW 3 |