|Posted: June 1, 2010, 8:36 pm - IP Logged|
Thank you!..yes slowly but surely..I just have a hell of time remembering what the colons..semicolons commas etc represent..as soon as I have to backtrack and search online for tidbits,I lose my train of thought..
I forgot to mention I'm using 2003..when i input your equation,it highlighted the desired area to count and I hit ctrl/shift/enter after i entered it but it still only does column A...however ,it initially responded(meaning a,b,and c were being counted) when I added =COUNTIF(A:C,E1:E10).I was able to paste it down the column but I ended up wrecking it doing something else and can't remember what I did
Thanks for your help!..I'll be toying with it after work tomorrow
"No matter how bad things may get, I'd like to thank my middle finger
for always sticking up for me.."