HI....I have tried to use a sum(if()) function on data that has been
imported using a sql query. The simple sumif function works fine,
but when I try to use multiple criteria I get a 0. Is there a problem
using the sum(if()) on this type of data?..........thanks....jim


--
jamdmd
------------------------------------------------------------------------
jamdmd's Profile: http://www.excelforum.com/member.php...o&userid=35142
View this thread: http://www.excelforum.com/showthread...hreadid=549013

try to use sumproduct



regards from Brazil
Marcelo

"jamdmd" escreveu:


HI....I have tried to use a sum(if()) function on data that has been
imported using a sql query. The simple sumif function works fine,
but when I try to use multiple criteria I get a 0. Is there a problem
using the sum(if()) on this type of data?..........thanks....jim


--
jamdmd
------------------------------------------------------------------------
jamdmd's Profile: http://www.excelforum.com/member.php...o&userid=35142
View this thread: http://www.excelforum.com/showthread...hreadid=549013

I'll give it a go. thanks for the tip.......jim


--
jamdmd
------------------------------------------------------------------------
jamdmd's Profile: http://www.excelforum.com/member.php...o&userid=35142
View this thread: http://www.excelforum.com/showthread...hreadid=549013