Hi Yunus,

Am Sat, 10 Mar 2012 15:20:51 -0000 schrieb Yunus:

Whats wrong with this formula =SUMPRODUCT((A25:A850<=26)*(C25:C850=1))

MID is a text function. Your 1 is text formatted. Use
=--MID(B25,5,1)
to change the 1 to number and your SUMPRODUCT formula is working.

You can also use
=SUMPRODUCT((A25:A850<=26)*(C25:C850="1"))
but I prefer the first suggestion.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2