Forum Discussion

Copper Contributor

Oct 08, 2020

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: ...

BI & Data Analysis

excel

Formulas and Functions

office 365

training

KaKruger

Copper Contributor

Oct 12, 2020

HansVogelaarcould you be so kind to help me with another? I'm trying now to break down the info from the three worksheets by month the expense occurred - so pulling the same info as last time except only if from column G the specific month is listed. Every time I try a formula it tells me I've added too many actions.

Thank you for any help you can offer

Karen

HansVogelaar

MVP

Oct 12, 2020

KaKruger

Something like this:

SUMIFS('Sheet A'!$D$2:$D$1000, 'Sheet A'!$F$2:$F$1000, "utilities", 'Sheet A'!$G$2:$G$1000, ">="&DATE(2020, 10, 1), 'Sheet A'!$G$2:$G$1000, "<="&DATE(2020, 10, 31))+SUMIFS('Sheet B'!$D$2:$D$1000, 'Sheet B'!$F$2:$F$1000, "utilities", 'Sheet B'!$G$2:$G$1000, ">="&DATE(2020, 10, 1), 'Sheet B'!$G$2:$G$1000, "<="&DATE(2020, 10, 31))+SUMIFS('Sheet C'!$D$2:$D$1000, 'Sheet C'!$F$2:$F$1000, "utilities", 'Sheet C'!$G$2:$G$1000, ">="&DATE(2020, 10, 1), 'Sheet C'!$G$2:$G$1000, "<="&DATE(2020, 10, 31))

KaKruger
Copper Contributor
Oct 13, 2020
HansVogelaarTHANK YOU!!! It worked perfectly! Thanks so much for your help!
Karen