Hello,
I have a formula such as below..
=SUMIF('MBX TO DBS'!$G$1:$G$818,"*livedb01*")
This will sum the values in G1-G818 that contain livedb01 on the "MBX TO DBS" sheet, however this is not exactly what I want.. I want the SUM function to look for the livedb01 string in G1-G818 and SUM the values in D1-D818.
So instead it would look for livedb01 text in G column and take the value from D and SUM those once the text qualifier was found in G column..
Is this possible with Excel?
Thank you.
Bookmarks