Adding Worksheet To Formula

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.

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
>
>