I have a spreadsheet for recording hours spent on various project. I want to break this down into months so I have the sum of the hours for each month. The only problem I have is that I can find the sum of hours, however there are fields in the range that contain H's indicating holiday. Anyone know how I can adjust the formula below to ignore Text values. At the moment it is giving me a #VALUE! error...
TimeTracker is the Sheet Name, the MATCH looks up the project name and References are worked off dates...
=SUMPRODUCT((MONTH(J$3)=MONTH(TimeTracker!$B$2:$HG$2))*(OFFSET(TimeTracker!$A$1,MATCH($B4,TimeTracker!$A:$A,0)-1,1,1,214)))
Any help would be great...