Do you mean the figures for a certain month? If so then use something like

=SUMPRODUCT(--(TEXT(LEADS!A2:A599,"mmm")="Mar"),(--(LEADS!C2:C599='BLDR LEAD
RPT'!A4),--(LEADS!Y2:Y599="Y"))


--
HTH

Bob Phillips

"ycart88" wrote in message
...
Thanks, Duke and Bob! You guys are the best! Say, if I had a date column
and wanted to narrow down the YTD field to MTD, would you happen to know
what
I could add to this formula? :)

THANKS again!!!
Tracy

"Duke Carey" wrote:

Maybe just a slight modification to Bob's formula (changes the first
range to
column C from column A)

=SUMPRODUCT(--(LEADS!C2:C599='BLDR LEAD RPT'!A4),--(LEADS!Y2:Y599="Y"))


"Bob Phillips" wrote:

=SUMPRODUCT(--(LEADS!A2:A599='BLDR LEAD
RPT'!A4),--(LEADS!Y2:Y599="Y"))

I think :-)

--
HTH

Bob Phillips

"ycart88" wrote in message
...
Hi all,

I'm been trying to figure this out for days... I need to take the
following
sales lead information and plug some data from it into the summary
page as
shown below...

DATA EXAMPLE (Sales Leads):

LEAD DATE SOURCE HOMEBUILDER ... APPT SET
(Column A) (Column B) (Column C) ... (Column Y)
3/28/05 Homebuilder ASH N
3/28/05 Homebuilder ASH Y

SUMMARY EXAMPLE:
Builder YTD Leads YTD Appts
ASH 43
CAC 33
CAL 8
COR 0

So basically, if the Homebuilder "ASH" has had a total of 6 Appts
Set
("Y"),
I'd like to put a count in the corresponding YTD Appts cell. Here's
how
far
I've gotten, and yes, I'm aware it's very flawed as I can only
figure out
how
to count ALL of the "Y"'s and not just the ones for that builder
("ASH").
lol Can you help?

=COUNTIF(LEADS!C2:C599,'BLDR LEAD RPT'!A4) -
COUNTIF(LEADS!Y2:Y599,"N")