Reference Column - ExcelBanter

wickedchew wickedchew is offline

Senior Member

Location: Philippines

Posts: 161

Quote:

Originally Posted by m2c2

I am trying to create a formula that will look at one column with the only values being True or False, then returning the True value(s) in an adjacent column (sum them up would be ideal) and divide them by the total number, which I believe is count.

I hope the picture answers your question.

Attached Images

__________________
Asobi Wa Owari Da

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel - changing column reference based on value of other column	Dharmesh Patel	Excel Discussion (Misc queries)	4	October 12th 09 02:41 PM
MS Excel - changing reference column value based on another column	Dharmesh Patel[_2_]	Excel Discussion (Misc queries)	2	October 12th 09 01:19 PM
Excel - changing column reference based on value of other column	Dharmesh Patel	Excel Discussion (Misc queries)	2	October 12th 09 01:18 PM
Row reference increment but preserve column reference	Pwanda	Excel Worksheet Functions	1	April 28th 05 01:12 PM
Macro to Reference Column Next to Current Reference	dolphinv4	Excel Discussion (Misc queries)	2	April 11th 05 08:36 AM

All times are GMT +1. The time now is 02:48 PM.

Menu

About Us