I need a formula to sum a range of cells in Column "E" based on text in Column "B" "Total" . The range of cells to copy is in Column "D"
B22= "Total"
D22= SUM(D18:D21) to copy
E22=SUM(E18:E21) to add
It is important to note that the range of cells in column "D" and "E" vary in each grouping.
Solved by A. J. in 13 mins