Excel data functions

[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

 

[Vasant Nanavati]

Hi:

Try something like:

=SUM(--(A2100=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(--(A2100="7:00"))

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

Regards,

Vasant.

 

[hrmlance]

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

 

[Harlan Grove]

Try something like:

=SUM(--(A2100=7/24))

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

....

Why not SUMIF(A2100,"07:00") ?

 

[Vasant Nanavati]

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.