=SUMPRODUCT(--(rng1="value1"),--(rng2=value2),--(rng3="value3"),rng4)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"TryHarder" wrote in message
...
nice = sum of product if many condition i make is okey. column A * column
B *
column C,D,E,F,G,H...if condition on column I (text) and condition J
(numbers) and many more...please assist...

"daddylonglegs" wrote:

Never seen such a function, what do you want to do?

"TryHarder" wrote:

i was read a post i think three days ago, but i cannot see a
sumproductif in
my excel. how to load it? thanks for any assistance. just new here...