number of cells

[M.K]

if i have the excel file include 6 sheet and i coulm A:A the name of products


how i can count all cell which include spesfic products for example in sheet
one 5 cell include the products a and sheet 2 100 cell have product a so the
total will be 105 also if i have more than one file with more than one sheet
how i can count ot

 

[Mike H]

Hi,

these 2 work fine for me

Column A - average of the times
=AVERAGE(A2:A5)

Column B average of the percentages

=AVERAGE(B2:B5)

A good tip is always pot your formula even if you know it's wrong.

Mike

 

[M.K]

hi

i dont want to know average but i want the following

a
b
c
a
b
c
a
a
i want to know how many cell include a so will be 4 in the above example
i can know it by =countif(A:A,"a") but i mean if i have more than 5 sheet
gow i can know all a by on formal also if i have more than file

 

[Fred Smith]

MK,

You'll have to translate your request into English. I was with you up to the
part where you said you knew you could use =Countif(A:A,"a"). But then you
said: "if i have more than 5 sheet gow i can know all a by on formal also if
i have more than file"

What does that mean?

Regards,
Fred.

 

[M.K]

I mean that

hi

i dont want to know average but i want the following

a
b
c
a
b
c
a
a
i want to know how many cell include a so will be 4 in the above example
i can know it by =countif(A:A,"a") but i mean if i have more than 5 sheet
how i can know all cells which a by formal also if i have more than one
excel file and want know the number of cells which have a