Thread
:
How do I set up an IF formula with multiple qualifiers?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Jim May[_3_]
external usenet poster
Posts: 16
How do I set up an IF formula with multiple qualifiers?
Try:
With Tommy Wheeler in Cell D1 - in cell E1 enter
=SUMPRODUCT(--(F2:F1000=D1),--(G2:G1000="Y")) ' Sumproduct prior to 2007
does not allow full column Reference (as you have used)
HTH
in article
, chubbs at
wrote on 9/10/08 10:51 AM:
I want to see how many people attended an event and then attribute it to that
specific sales person. In the raw data, the attended column is Y or N and
there is a column for the assigned sales guy. Here is my code that is not
working:
=SUM(IF((AND(F:F="Tommy Wheeler",'2007 regs '!G:G="Y")),1,0))
This output should tell me how many people registered within Tommy's sales
territory. Any help would be appreciated!
Reply With Quote
Jim May[_3_]
View Public Profile
Find all posts by Jim May[_3_]