Hi Everyone,
I'm new to all the Excel functions but have self taught everything I know just through reading and researching.
I've hit a problem that I've been having a crack at for 2-3 days now.
I have a stocklist and 12 tabs labelled January - December where we report the stock as used.
All Data is in drop down lists in the months in column L and the stock used is in column N.
I can get January to show up the in the stocklist using this function here:
=SUMIFS(January!N:N,January!L:L,"Name of Stocked Item")
I don't know how to add the other 11 months without an error coming up or if i'm even using the right function, weather I should be using COUNTIFS instead.
Any help would be massively appreciated.
Thank you.
Bookmarks