Hi
The below links should answer your question 1 (On the limitation)
http://support.microsoft.com/default.aspx/kb/166342
On using SUMIFS (this will be helpful)
http://techtites.com/2008/05/22/exce...le-conditions/
If this post helps click Yes
---------------
Jacob Skaria
"MurrayBarn" wrote:
I have had some very useful help from Jacob on an older version of Excel
where he sorted my problem out with SUMPRODUCT (see Problem with Syntax?
posted below):
=SUMPRODUCT(--(TEXT(B2:B20000,"mmyyyy")="012008"),--(C2:C20000="Motor"),(D2:D20000+E2:E20000))
The above formula works great, but I have two questions for Excel 2007 users:
1. If I convert B2:B20000 to B:B, why do I get a #VALUE error
2. Will SUMIFS do the above and if so, how?
Thanks