Confused by formulas.


Good afternoon,

I have a large quantity of ever expanding data on multiple worksheets in one workbook and I would like to count certain aspects and have them tabulated on another worksheet (report) of which I have made a copy from another work book.  Essentially creating one workbook from two that ultimately share the same basic data information.  I have attempted to use countifs sumifs vlookup and indexmatch.  What if any would be the best formula(s) to utilize to gather specific bits of  information from certain columns in the multiple worksheets and tabulate it on the report

Thanks in advance

1 Reply
Confused on your question-if there’s one...🙄 . I suggest: try to learn more excel with pivot tables, power query and power pivot. Or create databases and import your complex stuff in ms Access. Have a nice Weekend 😎
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies