Thread: Need formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Need formula

Maybe

=COUNTIF(A1:A50,13)
Mike

"Mrtvac" wrote:

Hi,

Don't know does this forumula exists in Excel so I need help.

I need to count different values in range of cells.

Example:
I have cell ranges with this values: 13, 14, 15, 16, 13, 13, 16

I need formula which will return:
3 values of 13
1 value of 14
1 value od 15
2 values of 16.

Is this possible in Excel?

Thank you in advance.

Regards.

--
Pozdrav,
M

http://www.unreal-net.com/
Jedini web imenik na kojem mozete zaraditi!

http://forum.unreal-net.com/
Jedini forum koji dijeli zaradu sa clanovima!