Reference functions

  • Thread starter Thread starter Joseph M. Yonek
  • Start date Start date
J

Joseph M. Yonek

I have a table with a series of columns that a summary table is referencing.

In columns e,g,h,i,j,k,l there is a simple yes or no in each row of data.
On the summary page I would like to populate a cell referencing each of
those columns and in each cell that has a yes in it I would like the summary
page to return the column heading for all columns that have a yes.

What would be the best way to do that?

Thanks in advance.
Joe
 
You may want to do a COUNTIF function. For example, in
cell e4 on the summary page, you could put =COUNTIF
(TABLE_REFERENCE,"=yes"), where TABLE_REFERENCE is the
cells you're concerned with, such as E4:E100. This
formula will count the number of yes answers. If all you
want the cell to return is a "YES" if any of the cells is
yes, try =IF(COUNTIF(TABLE_REFERENCE,"=yes")>0,"YES","NO").

Jane
 
Thanks Jane, but actually need to return the column heading not simply the
number of yes'.
 
Then try =IF(COUNTIF(TABLE_REFERENCE,"=yes")
0,HEADER_CELL,"") where HEADER_CELL is the location of
Click to expand...
the column name you need returned. Be sure to anchor it
with $ ($A1) if you're copying the formula down.

Jane
 
Back
Top