Hi

I have a spreasheet which shows a column of CLIENTS in Col A, Month_1 currency in COL B, Month_2 Currency in COL C and COL D states who the client belongs to.

It is laid out like this.

CLIENT MONTH_1 MONTH_2 ADMINISTRATOR

Client 1 2562.33 3162.55 Admin_1
Client 2 1000.00 1050.00 Admin_2
CLient 3 1000.00 950.00 Admin_1

TOTAL TOTAL
4562.33 5162.55

What I would like to do, is place in a cell below the two totals for the columns, another total. However, I would like the calculated total to only show where column D is showing a specific administrator, ie, Admin_1 and leave out any OTHER values that may be in columns B and C.

Not every record in column B will have a value and not every record in column C will have a value but all records will have at least either or both column b & C values.

I hope this clear.

Thanks in advance

Malcolm Davidson