software

Hiya,

Just wondering if you guys can help, I have desgined a quot;main consolequot;
where all the data is collected from other various sheets which contain
all the data.

I have a list of open and closed calls per month that i need a figure
from.
Example

On the main console i have quot;how many calls closed for marchquot; is there a
way i can use a lookup to check quot;closedquot; calls from another sheet and if
it matches it will add quot;1quot; in the column on the main console, therefore
giving me an overall amount of closed calls?--
Debz22
------------------------------------------------------------------------
Debz22's Profile: www.excelforum.com/member.php...oamp;userid=32215
View this thread: www.excelforum.com/showthread...hreadid=519653Just use COUNTIF

=COUNTIF('other sheet'!B:B,quot;closedquot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Debz22quot; gt; wrote in
message news
gt;
gt; Hiya,
gt;
gt; Just wondering if you guys can help, I have desgined a quot;main consolequot;
gt; where all the data is collected from other various sheets which contain
gt; all the data.
gt;
gt; I have a list of open and closed calls per month that i need a figure
gt; from.
gt; Example
gt;
gt; On the main console i have quot;how many calls closed for marchquot; is there a
gt; way i can use a lookup to check quot;closedquot; calls from another sheet and if
gt; it matches it will add quot;1quot; in the column on the main console, therefore
gt; giving me an overall amount of closed calls?
gt;
gt;
gt; --
gt; Debz22
gt; ------------------------------------------------------------------------
gt; Debz22's Profile:
www.excelforum.com/member.php...oamp;userid=32215
gt; View this thread: www.excelforum.com/showthread...hreadid=519653
gt;