Home

Confused by formulas.

Highlighted
CDStafford
Visitor

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
Highlighted
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
I need the Formual...
alanaj in Excel on
1 Replies
CHALLENGE
marcialfigueroa in Excel on
0 Replies
Nested IF Statement with VLOOKUP
JCPeterson13 in Office 365 on
1 Replies
Formula needed to reorganize data
illo-guy in Excel on
4 Replies