Hi. I have weekly data by Contract number over multiple worksheets. I want
to sum the hours associated with the contract. The contract information will
not always be in the same cell, as new contracts are constantly added. My
question is, should I use an If and then a SumIf or would a SumIf by
sufficient?

=SUMIF("'Apr 4:Jun 27'!, A5:A33",A5,"'Apr 4:Jun 27'!, G5:G33")

I'm obviously missing something here. I want this formula to look in
worksheets Apr 4 to Jun 27 in cells A5 through A33 and if there is a match to
cell A5 on my summary worksheet, then add corresponding figures in cells G5
through G33 and then put into cell G5 on my summary worksheet.

Help please :)