Hi again,

Am Fri, 28 Nov 2014 17:22:12 +0100 schrieb Claus Busch:

check the character in column B. I saw the hyphen. Evenutally there are
also one or more leading or trailing spaces in the cell. Then change the
hyphen with the cell content. Or run Data = TextToColumns for column B
to delete the spaces. The formula is correct.

if you cannot get it to work then add all values for column B in the
formula:
=SUMPRODUCT(($A$18:$A$35=F142)*(($B$18:$B$35=G144) +($B$18:$B$35=G145)+($B$18:$B$35=G146)+($B$18:$B$3 5=G147))*$M$18:$M$35)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional