Excel data functions

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

1. what is the function to count a row or coulmn and
return how many cells contain a value or a specific value.

2. what is the function to look up on a data base and
count the number of times a item apears in the data
base. ie how mnay times 7:00 appears
 
Hi:

Try something like:

=SUM(--(A2:D100=7/24))

entered with <Ctrl><Shift><Enter>.

If you are looking for 7:00 in a cell formatted for time, Excel will store
it as 7/24.

If you are looking for 7:00 entered as text, use:

=SUM(--(A2:D100="7:00"))

again, entered with <Ctrl><Shift><Enter>.

Regards,

Vasant.
 
=COUNTIF(A2:A5,"apples")
Will return the number of time apples is within the listed cells
 
Hi Harlan:

I assume you meant COUINTIF. Silly me, for some reason I thought COUNTIF
would not work on multiple columns, but of course it does.

Regards,

Vasant.
 
Back
Top