Hello you gurus. I am trying to use a folmula to sum some values based on TRUE in another column, i.e.
Column A has at various places a unique text value, "Total". I want to sum a value in the same row as "Total" but as Column B / Column D.
SUMIF seems to have potetial but only works on a single column and Vlookup seems to have potential but can't work on multiple values. Can they be combined?
Bookmarks