Excel 2010 IF

rather than image
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

i would use a pivot table and filter the results
Much easier to update and change

see what you think,

you could have mutliple pivot tables across the sheet if needed

or use an extraction to pull across the data
i just find pivot tables easy to manipulate this sort of data

the thing to do is have a wider range for your source data

The as you enter new data - you can refresh the pivot table , and everything will update

i have gone to sheet three
click on the pivot table
Analysis from the ribbon
then change data source
change from
Sheet1!$A$3:$G$10
to
Sheet1!$A$3:$G$1000

now when you add any new information up to row 1000
you then click on the pivot table
from the ribbon > analysis > refresh

now the new data appears in the pivot table