I have a list, from this list i can select through autofilter rows with certain values.
at the bottom of the list there are SUMIF cells that calculate values in specific cells in all rows.
however when i select a specific value with autofilter the calculation is done on all cells whereas i would like the calculation done on the cells selected by autofilter
at the bottom of the list there are SUMIF cells that calculate values in specific cells in all rows.
however when i select a specific value with autofilter the calculation is done on all cells whereas i would like the calculation done on the cells selected by autofilter