I can't get this formula to work. I suspect I'm missing something relatively simple.
IF(H6=".Last Three Months.",SUMPRODUCT(--('Data Entry'!F4:F503=>'formulas'!H1),--('Data Entry'!F4:F503=<'formulas'!H2),--('Data Entry'!K4:K503,"Yes"),SUMPRODUCT(--('Data Entry'!H4:H503=H6),--('Data Entry'!K4:K503="YES")))
The way i split it up by color is how I want it to go... IF(logical test,value if true, value if false. However, its just combining the green and black as the value if true. I've tried several different things... extra parenths, commas, etc. Nothing seems to work.
Thanks for the help.
Clint
IF(H6=".Last Three Months.",SUMPRODUCT(--('Data Entry'!F4:F503=>'formulas'!H1),--('Data Entry'!F4:F503=<'formulas'!H2),--('Data Entry'!K4:K503,"Yes"),SUMPRODUCT(--('Data Entry'!H4:H503=H6),--('Data Entry'!K4:K503="YES")))
The way i split it up by color is how I want it to go... IF(logical test,value if true, value if false. However, its just combining the green and black as the value if true. I've tried several different things... extra parenths, commas, etc. Nothing seems to work.
Thanks for the help.
Clint