functions on imported database

[jamdmd]

HI....I have tried to use a sum(if()) function on data that has bee
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 proble
using the sum(if()) on this type of data?..........thanks....ji

 

[Guest]

try to use sumproduct



regards from Brazil
Marcelo

"jamdmd" escreveu:

 

[jamdmd]

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