formula not working

[Toastis]

[[Main KPI Data 2011.xlsm]Main KPI Data Sheet!'$E:$X,"*"&"Giant"&"*"&"Sundial"& "*"&"&"Amigo"&"*")+Countif('Main KPI Data 2011.xlsm]Main KPI Data Sheet!'$E:$X,"11/3/10")]

Can I not do that?

I basically want it to count for 11/3/10 all findings for text containing Giant, Sundial and Amigo.

 

[Robert Mika]

Hi Toastis,
Instead of formula can you post example of your data.
You are trying to count a quite huge amount of data(range E:X) I hopeyou are not in Excel 07 or 10.
And I think we are missing here beginning of your formula

 

[Toastis]

I think I did leave some of the formula out inadvertently. I have a large data sheet Column E has dates column AM OR PM for that date. I need excel to find how many times AM deliveries were made on each date.

Essentially counting how many time 5/13 shows and then how many times 5/13 had AM Deliveries.

 

[Toastis]

I tried:

=SUMPRODUCT(--('[Main KPI Data 2011.xlsm]Main KPI Data Sheet'!$E:$E="5/5/2011"),--('[Main KPI Data 2011.xlsm]Main KPI Data Sheet'!$G:$G="AM"))

That results in zero.

 

[Robert Mika]

Maybe becouse your data in column E are date format whereas your "5/5/2011" is a text.
Put your date in any oher cell and try:

=SUMPRODUCT(--('[Main KPI Data 2011.xlsm]Main KPI Data Sheet'!$E:$E=A1),--('[Main KPI Data 2011.xlsm]Main KPI Data Sheet'!$G:$G="AM"))

where A1 is the date.(5/5/2011)