Need help with Excel formula

zyx2004, Jan 22, 7:05pm

king1, Jan 22, 7:23pm
or you could filter the data first to only include rows with Fee(paid), then a simple sum on the actual column data

zyx2004, Jan 22, 8:02pm
Hmm, yeah, looks like that might work. Thanks!

emmerson1, Feb 18, 2:49am
In a separate column, this will bring across the values or blank if not found;

Sum the values in E1:E7, if the value of the correspodig D1:D7 equals "Fee(paid)". I don't think you can use it for searching in a larger string.

Share this thread

Buy me a coffee :)Buy me a coffee :)