A Lookup + 1

[Debz22]

Hiya,

Just wondering if you guys can help, I have desgined a "main console" 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 "how many calls closed for march" is there a way i can use a lookup to check "closed" calls from another sheet and if it matches it will add "1" in the column on the main console, therefore giving me an overall amount of closed calls?

[Bob Phillips]

Just use COUNTIF

=COUNTIF('other sheet'!B:B,"closed")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Debz22" <[email protected]> wrote in
message news:[email protected]...
>
> Hiya,
>
> Just wondering if you guys can help, I have desgined a "main console"
> 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 "how many calls closed for march" is there a
> way i can use a lookup to check "closed" calls from another sheet and if
> it matches it will add "1" in the column on the main console, therefore
> giving me an overall amount of closed calls?
>
>
> --
> Debz22
> ------------------------------------------------------------------------
> Debz22's Profile:
http://www.excelforum.com/member.php...o&userid=32215
> View this thread: http://www.excelforum.com/showthread...hreadid=519653
>