M
Meenie
I want to count the number of "yes" in a range and the number of "n/a" in a
range and get that total.
If I enter =sum(if(range,"yes"+"n/a")) I get "#Value"
If I enter =sum(if(range,"yes")+(range,"n/a")) I get "formula contains an
error"
I've tried several variations on this with sum, sumif, count, counta,
countif...
Can someone please give me a clue??
Thanks, Meenie
range and get that total.
If I enter =sum(if(range,"yes"+"n/a")) I get "#Value"
If I enter =sum(if(range,"yes")+(range,"n/a")) I get "formula contains an
error"
I've tried several variations on this with sum, sumif, count, counta,
countif...
Can someone please give me a clue??
Thanks, Meenie