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: ...
Simply add the sums for each of the worksheets:
=SUMIF('Sheet A'!$F$2:$F$1000, "utilities", 'Sheet A'!$D$2:$D$1000)+SUMIF('Sheet B'!$F$2:$F$1000, "utilities", 'Sheet B'!$D$2:$D$1000)+SUMIF('Sheet C'!$F$2:$F$1000, "utilities", 'Sheet C'!$D$2:$D$1000)
Substitute the actual names of the sheets, and adjust the ranges if they extend below row 1000.
Thank you HansVogelaar !
I did have to remove the absolutes but then it worked perfectly!
Thanks again
Karen