Hello Everyone! I'm having problems with using sum, sumif or sumproduct to add cells that aren't in a range (ie A1:a10), instead like this: a1, c3, d5, etc. This is because I think, the Null string & empty cells. Does anyone have any ideas??? Thanx 4 any help!!! God Bless...