I read that posting and tried the following.
=SUMIF(A5:A312,">="&DATE(2004,31,12),D5:D312)-SUMIF(A5:A312,">*"&DATE(2005,1,1),(D5:D312="Approved"))
It returned 0. That is when I started playing around with SUMPRODUCT. I have been trying to figure this out for about a week. Working on it off and on durring my work day. Could you please look at the above formula? I am not very good at this and must have made a mistake. You have been very helpfull so far and I do appreciate it so much.
Bookmarks