A Lookup + 1

D

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