Need help with Excel formula

zyx2004, Jan 22, 7:05pm
I?

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

https://support.office.com/en-us/article/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e


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