I have a sheet with rows as follows (Date formatted as Excel Date, Actual, Difference), with one set of 3 columns for each week of the year.
Values in the first column represented contracted hours for the week for a given client.
The second column will be how many hours the work actually took.
The third is the difference.
In one of the final columns, I need a sum of all the contracted hours - those that are in columns with dates as headers.
Here's what I've tried: =SUMIF(J1:FO1, ISNUMBER(J1), J2:FO2)
Where J1:FO1 are the headers (ex. 1/5/18, Actual, Difference), the ISNUMBER statement resolves to True when J1 is a date (which resolves as a number), and J2:FO2 is the first row of client data.
Although this doesn't throw an error, it also doesn't actually add the numbers in J2:FO2.
Any ideas?