Populate data only when project is "complete"

Hi guys,

I am putting the finishing touches on a spread sheet and only have one last thing to do. Attached is a spread sheet for reference.

You will see in the April tab that there is a box with "Comp" labeled at the end of the data. Once a particual project has been complete the idea is to put an x (or otherwise marked) in that box and have the totals page only count those numbers IF the project is complete. Anything that does not have the x in the completed box should not transfer to the total tab.

One problem I am running into is that I already have formulas in the cells of the totals tab so I'm not sure how to put multiple forumlas into a cell or if it can be done.

I have been searching thru the forum to see if I could figure this out on my own but I'm not coming up with anything that seems like it would work in my situation. Any help on this would be a huge benefit, my boss wants this spread sheet done ASAP - as most bosses do

Thank you!
Andreahelp1.xlsx

i added to the formula in sheet2 G6, but am unable to test it, because it links to a file on your network....

=IF(ISERROR(VLOOKUP(A6,April!$B$3:$B$13,1,FALSE)),"",AVERAGEIF(CODEAP,A6,CKAP))

let me know if this gives you what you need?

u are using Excel 2007, so i suppose u have the SUMIFS formula. Otherwise, u can use SUMPRODUCT

sorry for the delay. before i try to play around with your 2nd file (which is considerably different to your original file), did you try my suggestion in the 1st file you uploaded? like i said, i was unable to test it due to links to your network, and i was hoping that you would test it for yourself before sending another file?

with regards to benishiryo
here's with your named ranges using sumifs

=SUMIFS(APCOST,APPROJECT,A2,APCOMPLETE,"=x")

main thing is, your question was resolved