Forum Discussion
Advanced Excel formula to pull $ based on keywords from 3 different worksheets
Hi - I've done basic formulas in Excel but now I need one to pull info from multiple sheets from one column based on a keyword from another column, and sum total it in its destination cell. Example: ...
Can you make a formula me if possible. I have to do the sum of instances of different columns in x with keywords such as elopement, functional communication etc occured. Column Y has amount of each word that corresponds to each keywords . I just need the total from each key work column. Thank you
Could you attach a sample workbook, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?