K
Khalil handal
Expensescode is a range for items,
Expensesmonth is a range for months.
H7:H800 is a range of currency.
First, I filter the cell B6 to select a month from the Expensesmonth.
What formula do I need to have in cell H5 to do the following:
have the sum of all filtered cells in range H7:H800 with all values of
Expensescode except those values with relative expensescode of 999 and 888.
Any help is appriciated
Expensesmonth is a range for months.
H7:H800 is a range of currency.
First, I filter the cell B6 to select a month from the Expensesmonth.
What formula do I need to have in cell H5 to do the following:
have the sum of all filtered cells in range H7:H800 with all values of
Expensescode except those values with relative expensescode of 999 and 888.
Any help is appriciated