View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Help with cell function[_2_] Help with cell function[_2_] is offline
external usenet poster
 
Posts: 33
Default count data from one sheet to another

I have 2 worksheets. The 1st is "consult tracking" In this sheet I have
columns of "inappropriate consults" cell (L4 - L458) that gets an x if
criteria is met and "provider" cell (C4 - C458) that gets a providers name
ie. burt.

The 2nd sheet is "inappropriate" that has provider names and needs to be
able to count the totals from the sheet "consult tracking" Is this possible?

I want the cell in "inappropriate" (B!) to count the information from
consult tracking.