Need help: Excel 10' Forumla

[DigitalCancer]

Hey Guys,

I could use a little help. I'm not terribly great with all of the formula's that're built into Excel but I am aware of there usage.

So, I've created an equipment inventory sheet that I want to use to track our assigned equipment to users (machine, servers, kb, mouse, etc.). The way I have it currently setup is great but I'm wanting to find a way to display what I currently have in stock.

So..I have a Type/Count table setup that calculates and displays how many items are currently in my inventory sheet. What I'm trying to trigger now is a separate table and I got it half working by using **=COUNTIF(tblData[Owner],"UNASSIGNED") which is looking at the inventory sheet and checking the Owner field for the text UNASSIGNED, works perfect, but, I need a 2nd check and an 'AND' statement b/c it needs to meet both requirements.

So, I need the Owner field to be UNASSIGNED AND LOCATION to be Chicago Heights (Stock) OR Mokena (Stock)

Is this possible? What's the best way to go about getting this to work?

 

[DigitalCancer]

Resolving my own post BUT...I wanted to help anyone else out if they're ever looking for this solution:

So I have a list sheet that has all the equipment type, location, and users. I want to keep a running count on how many we have total AND how many we have in stock, so in the location I created a 'Location Stock' tag.

So, here's my formula:

=COUNTIFS(tblData[Type], "Keyboard",tblData[Location],"Chicago Heights Stock", tblData[Location],"Mokena Stock")

This pulls a count for all "Keyboard" that has a location of Chicago Heights Stock and Mokena Stock. ^_^