Results 1 to 10 of 10

Counting Multiple options

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

09-14-2016, 08:10 PM #4
sanram

View Profile

View Forum Posts

Visit Homepage
Valued Forum Contributor

Join Date

06-21-2013

Location

Bangladesh

MS-Off Ver

Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013

Posts

975
Re: Counting Multiple options
Or you can try this too

=SUMPRODUCT(LEN(D3:AS3)-LEN(SUBSTITUTE(D3:AS3,"X","")))
Register To Reply

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

Toggle multiple options buttons with a single options button

By bests in forum Excel General

Replies: 0
Last Post: 08-26-2014, 08:44 AM
VBA - 1 pivot filter control multiple pivots with multiple field options

By bwolsky in forum Excel Programming / VBA / Macros

Replies: 0
Last Post: 03-28-2014, 06:19 PM
[SOLVED] counting multiple options as 1

By cherryt in forum Excel Formulas & Functions

Replies: 4
Last Post: 08-01-2013, 08:38 AM
macro for counting with matching criteria of two different options

By tarun9860 in forum Excel Programming / VBA / Macros

Replies: 2
Last Post: 05-06-2012, 09:54 PM
Multi-Column Counting - COUNTA or other Options

By argomike in forum Excel Formulas & Functions

Replies: 34
Last Post: 01-28-2012, 03:54 PM
Counting Multiple Options

By johnlovesbeer in forum Excel Programming / VBA / Macros

Replies: 6
Last Post: 12-06-2009, 11:38 AM
counting list options

By Tatsu in forum Excel Formulas & Functions

Replies: 1
Last Post: 02-13-2008, 01:52 PM

Tags for this Thread

countif combined?

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

All times are GMT -4. The time now is 08:54 PM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1