Posted to microsoft.public.excel.worksheet.functions
|
|
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!
|