functions on imported database

[jamdmd]

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

[Marcelo]

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
>
>

[jamdmd]

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