Total of Certain Value Across Multiple Sheets
Hello! Hoping someone here can help. I have 6 sheets that are identical in setup and parent rows (inventory for each vendor - Child rows are only varience being actual inventory). I'm needing a summary sheet that totals the quantity across each of the 6 vendor sheets. I've tried a variety of index/match/vlookup/countifs/sumifs but I can't seem to figure it out.
Help Article Resources
Check out the Formula Handbook template!