I need a formula to sum up the numbers in column A based on names in 10 other columns and dates in 26 other columns. IE... if X name is anywhere in Columns E-N row 1, 5, and 7 and Y date is also in row 1, 5, and 7 (In Columns AA-ZZ) - then the sum of the hours in 1, 5, and 7 will be added together.