Hello

I have data in two columns: column A having dates and a corresponding amount in column B.

Now in column C, I would like to have a formula which would sum the last 10 rows in column B which do not have a weekend in column A, i.e., sum only numbers in column B which is correspond to a weekday for the last 10 weekdays.

Any help would be appreciated.