Summing filtered rows with 2 conditions

[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

 

[Shane Devenshire]

Hi,

What is a "relative" expense code?

Thanks,
Shane Devenshire

 

[Khalil Handal]

"relative" is used in the meaning of "that has the value of"
Hope this helps!!!