K
Khalil handal
Hi,
The range K7:H794 has range name of expensescode. In cell H5 the formula is
=SUBTOTAL(9,H7:H794). This gives the SUM of the mentioned range.
I used the SUBTOTAL because I might use the filter depending on expensescode
and have he sum.
What changes do I need so that the sum in cell H5 does not include the
amounts in colomn H (numbers with currency format) that has an expensescode
of 999 or 888 not to be included in the total.
i.e. If the expensescode is 999 or 888, do not include that number in the
summation.
The range K7:H794 has range name of expensescode. In cell H5 the formula is
=SUBTOTAL(9,H7:H794). This gives the SUM of the mentioned range.
I used the SUBTOTAL because I might use the filter depending on expensescode
and have he sum.
What changes do I need so that the sum in cell H5 does not include the
amounts in colomn H (numbers with currency format) that has an expensescode
of 999 or 888 not to be included in the total.
i.e. If the expensescode is 999 or 888, do not include that number in the
summation.