LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SJC SJC is offline
external usenet poster
 
Posts: 22
Default Conditional formula drop down box

Any help with this formula would be greatly appreciated.

In cells under column C, I have a drop down box with people's names,
followed by some data collection cells in coumns D through I. Columns D
through I are marked with an 'x', if that data point is true for that person.

For each person's name, I need to count the number of instances the 'x' is
printed for specific columns D through I. I have additional columns set up
to collect this information. I tried writing a simple if/then formula, but
the result is always false, even when it should be true. Any advice on how
to do this correctly?

Thanks much.
 
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
conditional drop down menu Anamillia Excel Discussion (Misc queries) 1 October 25th 07 08:24 PM
Conditional drop down list Pieter van der Walt Excel Discussion (Misc queries) 3 March 7th 07 10:25 AM
Conditional Drop Down List Bogo Excel Discussion (Misc queries) 2 February 16th 06 09:11 PM
Conditional drop-down lists Paul Green Excel Worksheet Functions 2 October 17th 05 04:28 AM
How do i set up conditional drop-down list Vikas New Users to Excel 3 June 23rd 05 01:17 PM


All times are GMT +1. The time now is 10:39 PM.

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"