Tiger Trauma
09-15-2006, 05:53 PM
I was just wondering if anyone could help me out here.
I'm trying to creat some formula's for the whltop 10 thread to make the counting much easier, so i can pretty much just copy and paste, instead of taking an hour to count everything.
here's what im working on
=IF(A2="Vancouver",1,0)
How do i get it to say
If cell a2,b2,c2, (and so on till it reaches that last vote) =vancouver add 1 for each cell that says vancouver?
EDIT**
Lol nevermind i did some research and finally found out how do to it
=COUNTIF(Sheet1!A2:IU2,"Vancouver")
I'm trying to creat some formula's for the whltop 10 thread to make the counting much easier, so i can pretty much just copy and paste, instead of taking an hour to count everything.
here's what im working on
=IF(A2="Vancouver",1,0)
How do i get it to say
If cell a2,b2,c2, (and so on till it reaches that last vote) =vancouver add 1 for each cell that says vancouver?
EDIT**
Lol nevermind i did some research and finally found out how do to it
=COUNTIF(Sheet1!A2:IU2,"Vancouver")