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.

Conditional formula drop down box
 

To count apply this formula in cell J2
=COUNTIF(D2:I2,"x")

or to return true false
=COUNTIF(D2:I2,"x")0

or
=IF(COUNTIF(D2:I2,"x"),"True statement","False statement")


If this post helps click Yes
---------------
Jacob Skaria


"SJC" wrote:

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.

Conditional formula drop down box
 

These formulas will certainly give me the count, but I need them to be
counted by each person's name in the drop down box, which is in column C. I
have a column set up for each person name to collect this information, but
the formula returns them all false.

Here's an example, if the name JOHNSON is chosen from the drop down box in
column C, then I want an x to be returned to column J. However, if a
different name other than JOHNSON is in column C, then I want column J to
remain blank.

"Jacob Skaria" wrote:

To count apply this formula in cell J2
=COUNTIF(D2:I2,"x")

or to return true false
=COUNTIF(D2:I2,"x")0

or
=IF(COUNTIF(D2:I2,"x"),"True statement","False statement")


If this post helps click Yes
---------------
Jacob Skaria


"SJC" wrote:

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.

Conditional formula drop down box
 

Do you have a list of names and corresponding information elsewhere to do a
lookup.

Post few sample...someone here should be able to help..



"SJC" wrote:

These formulas will certainly give me the count, but I need them to be
counted by each person's name in the drop down box, which is in column C. I
have a column set up for each person name to collect this information, but
the formula returns them all false.

Here's an example, if the name JOHNSON is chosen from the drop down box in
column C, then I want an x to be returned to column J. However, if a
different name other than JOHNSON is in column C, then I want column J to
remain blank.

"Jacob Skaria" wrote:

To count apply this formula in cell J2
=COUNTIF(D2:I2,"x")

or to return true false
=COUNTIF(D2:I2,"x")0

or
=IF(COUNTIF(D2:I2,"x"),"True statement","False statement")


If this post helps click Yes
---------------
Jacob Skaria


"SJC" wrote:

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.

Conditional formula drop down box
 

Oh silly me, I usually use data validation to do this, but had a regular
combo box there instead, which of course was not populating the cell. Thanks
for your help.

"Jacob Skaria" wrote:

Do you have a list of names and corresponding information elsewhere to do a
lookup.

Post few sample...someone here should be able to help..



"SJC" wrote:

These formulas will certainly give me the count, but I need them to be
counted by each person's name in the drop down box, which is in column C. I
have a column set up for each person name to collect this information, but
the formula returns them all false.

Here's an example, if the name JOHNSON is chosen from the drop down box in
column C, then I want an x to be returned to column J. However, if a
different name other than JOHNSON is in column C, then I want column J to
remain blank.

"Jacob Skaria" wrote:

To count apply this formula in cell J2
=COUNTIF(D2:I2,"x")

or to return true false
=COUNTIF(D2:I2,"x")0

or
=IF(COUNTIF(D2:I2,"x"),"True statement","False statement")


If this post helps click Yes
---------------
Jacob Skaria


"SJC" wrote:

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.