Forum Discussion
Solved
Formula for total dependent on value of a cell
Hi Is it possible to enter a formula that totals a column, but is dependent on another number in each row as to whether it is included in the total? I have recreated a simple table to demonstra...
=SUMIF($A$2:$A$5,$A8,B$2:B$5)You can try this formula which is in cell B8 and filled across range B8:E9.
=SUMIF($A$2:$A$5,$A8,B$2:B$5)You can try this formula which is in cell B8 and filled across range B8:E9.
Amazing, thank you so much!!