Copy data if

Hi,

I am trying to set up a spreadsheet to be able to track and calculate how much is spent for certain client services across 5 offices.

I believe the formula is either filter or If i just can not work out how to set it up.
e.g
Site A spent $200 on whitegood paid via Visa Card.

i want to get this information into another table.

I think we're going to need a lot more information. First thing, please read the yellow banner at the top of the page. Attaching a sample WITH IT MOCKED-UP WITH EXPECTED RESULTS will go a long way in getting a good answer.