Apologies first. Nested IF issue and no time to do proper se

[ajm]

hi all. its been a while. have moved interstate from the last role, changed career, and am about to be a dad! woohoo! have obviously gone a bit rusty since the last role.

I have what should be a simple If formula.

=IF((E49:E58)="Yes",COUNTA($A$49:$A$58),"")

Column E is a list of Yes or No, and column A is a list of names. Why won't this work. I have tried entering it as an array but, get ready for this, I am using a Microsoft Keyboard on an Apple Mac machine so don't know how to enter the array properly.

Anybody care to have a shot at the (somewhat tarnished and grubby) title?

 

[Aladin Akyurek]

Re: Apologies first. Nested IF issue and no time to do prope

hi all. its been a while. have moved interstate from the last role, changed career, and am about to be a dad! woohoo! have obviously gone a bit rusty since the last role.

I have what should be a simple If formula.

=IF((E49:E58)="Yes",COUNTA($A$49:$A$58),"")

Column E is a list of Yes or No, and column A is a list of names. Why won't this work. I have tried entering it as an array but, get ready for this, I am using a Microsoft Keyboard on an Apple Mac machine so don't know how to enter the array properly.

Anybody care to have a shot at the (somewhat tarnished and grubby) title?

You need to state what you want to achieve. A non-working and/or incorrect formula does not convey that info.

 

[Norie]

What do you actually want to do?

Couldn't you use COUNTIF?

 

[ajm]

very good points. what am i trying to do. never really sure.

however, in this case, countif is perfect. was simply trying to count the number of times i get a "yes" in the list. small case of overthinking going on this afternoon. thanks.

 

[XLGibbs]

The reason your COUNTA function does not work, is that formula counts any occupied cell in the applicable range.