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:

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?