Thread: How to calculate number of occurencies of a specific number number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default How to calculate number of occurencies of a specific number number
=COUNTIF(E10:F17,"="&E5)

Regards,
Stefi

€žStefan€ ezt Ć*rta:

Hi,
IĀ“m trying to calculate number of occurencies of a specific number, IĀ“m
using data from different sheets
Formula:
=NUMBER.IF('sheet2'!E10:S10;"=E5") --error
NUMBER.IF('sheet2'!E10:S10;=E5) -- error

=NUMBER.IF('sheet2'!E10:S10;E5) -- Correct but not what IĀ“m looking for,
this give me the answer of number of occurencies of the number 3. IĀ“m looking
for 3 and above.

E5 represent the number, for example 3 and higher

BR
Reply With QuoteReply With Quote