LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 110
Default Count Common Denominator, but excluding "#value!"

i want to count the (common denominator in a cell range a.k.a (which number
appears the most")


in F6 to F200 contain formulas as described below giving me a value from
another cell. ex" #4"
ex: (=e6) which gives me "4" from "E6"
(=e7 ) which gives me "5" from "E7"
(=e8) wich gives me "5" from "e8"
to row 200

Some cells "give me "#value!"

In G1 i tried this formula but it does not work since it cant count the
cells with "values"

=mode(F6:F200)

How can i use the same formula but also to ignore "value" errors and to
finally give me the comon denominator. Which from the above examle number 5
appears the most.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I alphabetize data excluding words like "a" and "the"? Faith Excel Discussion (Misc queries) 6 November 11th 09 05:50 PM
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" LEJM Excel Discussion (Misc queries) 2 November 15th 07 07:49 PM
How to create a scatter chart with 2 "X" values with common "Y"s M_LeDuc Charts and Charting in Excel 2 September 13th 07 10:26 PM
Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z))) Prasad Excel Discussion (Misc queries) 2 June 27th 06 06:39 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"