I need the formula that will pull the info from the Overall worksheet. My
CountIf formulas work fine when they are on the Overall worksheet where all
the info is. Now I want to calculate that info but have it pull over to
another worksheet.

"rsenn" wrote:


Roy,

Two things.

One, the syntax of your COUNTIF formula seems to be wrong. It
apparently should be COUNTIF(range,criteria). I get an error message
when I try your formula.

Two, I'm having a hard time divining what you mean by "remaining
formula." Can you explain that.

Sorry I couldn't help as is.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=487414