Excel inventory control

[hecmar]

Hi

As per the attached. I cannot get there, what I am asking is that in sheet 1 there is a list of items, but in sheets 2 and 3 there maybe multiple of the same items. I need to count the items marked as "inventory" only as a number from sheets 2 and 3 onto sheet 1 corresponding with that particular item. Hope I make sense as its my first time here.

Thanks in advance

[Yogi52o]

Try this out. Could get a little fancier and base the sheet lookup based on the header of Sheet 1, but I think the attached will get you what you want.

[hecmar]

thanks Yogi52o really appreciate your assistance

[sktneer]

Hi hecmar,
Welcome to the Forum.

Or this...

On Sheet1
In B3

=COUNTIFS(INDIRECT("Sheet"&COLUMNS($A1:B1)&"!A:A"),$A3,INDIRECT("Sheet"&COLUMNS($A1:B1)&"!B:B"),"INVENTORY")

and then copy across and down.

[hecmar]

thanks for your help sktneer I can now see the logic

[sktneer]

Though Yogi's formula was perfect to get the desired output, my logic was to use a single formula for both the sheets. It is just another approach to that formula nothing else.

If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

[hecmar]

Thanks Yogi. I will remember the * (star) to recognise those who have put their time and effort to help me in this forum, which is great.