Counting data from sheet to sheet

  • Thread starter Thread starter Help with cell function
  • Start date Start date
H

Help with cell function

This is what I need. I want a cell in one worksheet to count if certain
criteria are met. On the source worksheet, I have several columns with
different data in them, I only need to count data from 2 cells. If there is a
X in one cell and in one of the other cells there is a name, ie burt. Can I
add this up on another worksheet, so that everytime there is a cell with an x
and a cell with burt in the same row, can this count on another sheet?
 
Your question is not clear enough, but if you have x-es in sheet2 column G
and names in column H then
=SUMPRODUCT(--(sheet2!G1:G6="x"),--(sheet2!H1:H6="burt"))
counts cases when there is "burt" next to an x.

Adjust ranges!

Regards,
Stefi



„Help with cell function†ezt írta:
 
that is close I feel...not quite though. Maybe I didn't do it correctly. I
have 2 sheet, one is "inappropriate" cell (L4 - l458) and one is "consult
tracking" cell (c4 - c458). I want the cell in "inappropriate" (B!) to count
the information from consult tracking. Do I put your formula in
"inappropriate"?
 
this is the formula that works if I put it in the same sheet, but I need to
put it in another sheet.
=SUMPRODUCT(--(L4:L463="x"),--(C4:C463="dr lim"))
 
Back
Top