COUNTING - MULTIPLE COLUMNS-MULTIPLE WKSHTS

  • Thread starter Thread starter Barbara
  • Start date Start date
B

Barbara

From 10/16/2003 note: COUNTIF will not work. Also use
SUMPRODUCT(N(RANGE=CRITERIA)*(RANGE=CRITERIA)). Key is
to be certain your data column(s) are formatted text
via "Data to Text" drop-down, not from Format-Cells drop-
down AND that the cell where the formula is placed is
formatted general.
 
Barbara,
It's always nice to continue a thread so we will have some idea of what you
speak. It's an archive thing too.
Is there a question here?
 
Back
Top