Formula Question
Sorry if my last post was overly complicated. I was trying to clarify the
whole picture and probably achieved the opposite.
I was hoping not to have to take the time to figure out what set of
arguments are required to return each of the specified results listed in the
"Where" section of my last post. For instance, what set of arguments would be
required in a Sumproduct function to achieve this:
Return all rows where B3 equals Column B on Details tab And where
Column L equals F And where M3 equals Column M on Details tab
I was thinking something like this. These are just examples of arguments
from your original post that I copied and pasted:
SP1:
--(MONTH(Detail!$J$2:$J$49706)=MONTH(B15)),--(YEAR(Detail!$J$2:$J$49706)=YEAR(B15)),--(Detail!$N$2:$N$49706=1),--(Detail!$Q$2:$Q$49706=0),--(Detail!$L$2:$L$49706="F")...
SP2: ...... etc.
You already know this. It will make it easier for me if you sort this out.
Greg
|