Excel question

Reply #3

phileight — Thu, 03 Jun 2010 01:43:12 GMT

try entering you function then press enter

with this function the a:c define the range you want to compare. the range would be entered as a1:c10 or what ever range you want. the ,e1 tells it what to compare to . if you had 10 sets of numbers to check the formula or function would be =countif(a1:c10,e1) second line would be =countif(a1:c10,e2) etc finish each entry with enter.

to use copy and paste you will need to tell excel that a1:c10 is a constant that does not change

the first entry... [ More ]

Reply #2

JonnyBgood07 — Wed, 02 Jun 2010 00:36:45 GMT

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... [ More ]

Reply #1

Raven62 — Tue, 01 Jun 2010 22:26:47 GMT

=COUNTIF(A:C,E1)

Learning Excel

Excel question

JonnyBgood07 — Tue, 01 Jun 2010 20:14:11 GMT

I'm trying to make cell B and C count but don't understand where/how to put the argument

I want to put digits in A B and C...

D is the counter column and E is the digits 1 thru 0 column..all I have so far in column D is ..=COUNTIF(A:A,E1) which works for row A

Can I include B and C within this equation somehow or do I have to make a separate one?

Any Help would be appreciated