Hi!
Sumproduct itself won't accept wildcards. Try this:
=SUMPRODUCT(('Jan 05'!$B$2:$B$4963="20 ")*(LEFT('Jan
05'!$C$2:$C$4963)="H")*'Jan 05'!$D$2:$D$4963)
Biff
"Charles" wrote in message
...
=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?
|