I have a large CSV (less than 1000 lines).
I want to make totals of a columns of cells - but based on specific conditions.
Like only total if column A value contains text 'XYZ pqr' and column E is more than zero - in which case, add to total of values in column E.
Hope that makes sense.
I'd like to be able to add other conditions as well if needed.
Not sure where to start with this one.
Any help would be great.
Thanks.
Bookmarks