C
ColleenK
I am trying to sum a column based on 2 sets of criteria, the first criteria
stipulates that the data being summed is <= a date, the second criteria
defines a name, when met it sums hours. The formula I used is:
=sumproduct((H:H<=m7),(Q:Q=A11),K:K)
Where m7 is a date & A11 is a name
It keep returning #NUM! please help
stipulates that the data being summed is <= a date, the second criteria
defines a name, when met it sums hours. The formula I used is:
=sumproduct((H:H<=m7),(Q:Q=A11),K:K)
Where m7 is a date & A11 is a name
It keep returning #NUM! please help