=SUMPRODUCT(('Jan 05'!$B$2:$B$4963="20 ")*('Jan
05'!$C$2:$C$4963="H*")*'Jan 05'!$D$2:$D$4963)
In above example I would like to sum certain celss if c2 through c4963 has a
string that starts with an H and I dont care what follows. I used the * as
wildcard but I don't think it is right as it does not work. How do you do
this?