hi
I have a date range in column A and I want to sum each of the values in H and I is the date in A matches Z so but my formula doesn't seem to like summing H and I. It work fine with one of the columns but not both. The formula I'm typing is =SUMIF(A:A,Z4,H:I).
Seems straight forward but i...