G
Guest
Hi! In my workbook:
Column A = the days of the week - Monday, Tuesday, etc. (but Monday may be
listed from A1:A10, and Tuesday from A11:A15)
Column B = Date (of Monday, Tuesday, etc)
Column C = Job Titles (text)
Range D:T contain numerical values
I want to write a formula that sums all the values in column D that also
contain Monday in column A and a specific value in column C. Is there any
formula out there that would accomplish this? I've tried SUMIF, but it isn't
working for me; I may be writing it wrong. Any ideas?
Column A = the days of the week - Monday, Tuesday, etc. (but Monday may be
listed from A1:A10, and Tuesday from A11:A15)
Column B = Date (of Monday, Tuesday, etc)
Column C = Job Titles (text)
Range D:T contain numerical values
I want to write a formula that sums all the values in column D that also
contain Monday in column A and a specific value in column C. Is there any
formula out there that would accomplish this? I've tried SUMIF, but it isn't
working for me; I may be writing it wrong. Any ideas?