where is sumproductif

T

TryHarder

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

TryHarder

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

Don Guillett

That was a strange thread. Pay no attention .sumproduct is already an IF
formula that uses criteria.
 
B

Bob Phillips

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

--

HTH

Bob Phillips

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

daddylonglegs

Well as, an example, you can multiply column A by B by C if D = "x" and E = 5
- then sum all the results....

=SUMPRODUCT(A1:A100,B1:B100,C1:C100,--(D1:D100="x"),--(E1:E100=5))
 
T

TryHarder

but i cannot see what you mean from files function help, is it safe, i am
working for accounting section...thanks for guiding mee....
 
E

Epinn

Thank you, Biff. I was thinking the same thing.

I think we can add

p (see below)
romelsb
to your list.

From: "p" <[email protected]>
Subject: Re: A ? for our Excel Guru's and MVPs
Date: Monday, November 20, 2006 2:21 PM

Bob, remember romelsb? He is the one who was very loud about the TODAY( ) in a report title for the lst half of the month and also for the second half of the month when Roger and you had a template in mind.

I just don't think that the culture of this forum can transform in such a short period with *a bunch of people* questioning about ......

What's next?

Epinn

TryHarder
driller
4pinoy
art

All the same person

201.202.129.226 ???

Biff
 
B

Biff

Not that that's a bad thing!

It's obvious that English isn't their first language and it's hard to
understand them sometimes.

Biff

Thank you, Biff. I was thinking the same thing.

I think we can add

p (see below)
romelsb
to your list.

From: "p" <[email protected]>
Subject: Re: A ? for our Excel Guru's and MVPs
Date: Monday, November 20, 2006 2:21 PM

Bob, remember romelsb? He is the one who was very loud about the TODAY( )
in a report title for the lst half of the month and also for the second half
of the month when Roger and you had a template in mind.

I just don't think that the culture of this forum can transform in such a
short period with *a bunch of people* questioning about ......

What's next?

Epinn

TryHarder
driller
4pinoy
art

All the same person

201.202.129.226 ???

Biff
 
E

Epinn

Not that that's a bad thing! <<

Not a bad thing to use different user names and ask the same question (e.g. SUMPRODUCTIF) over and over?

Can you clarify and elaborate?

Are you referring to culture shift?

I am not sure if we have the same frame of reference.

By "culture" I don't mean ethnicity.

From the dictionary - the set of shared attitudes, values, goals, and practices that characterizes an institution or organization <a corporate culture>

In this case, it is forum culture.

What I try to say is that all of a sudden there seems to be a bunch of people (when in fact there is only one) questioning about the integrity of formulae posted, Excel, MVP's etc. etc. which is a deviation from the day to day practice of users helping users solve problem. This is the culture (shared attitude, values, goals etc.) I am referring to.

I'll do my best to keep quiet in the next few days unless there is a need for me to clarify. Remember I said I drew too much attention to myself?

Epinn

Not that that's a bad thing!

It's obvious that English isn't their first language and it's hard to
understand them sometimes.

Biff

Thank you, Biff. I was thinking the same thing.

I think we can add

p (see below)
romelsb
to your list.

From: "p" <[email protected]>
Subject: Re: A ? for our Excel Guru's and MVPs
Date: Monday, November 20, 2006 2:21 PM

Bob, remember romelsb? He is the one who was very loud about the TODAY( )
in a report title for the lst half of the month and also for the second half
of the month when Roger and you had a template in mind.

I just don't think that the culture of this forum can transform in such a
short period with *a bunch of people* questioning about ......

What's next?

Epinn

TryHarder
driller
4pinoy
art

All the same person

201.202.129.226 ???

Biff
 
B

Biff

They're just asking questions. They're kind of eclectic questions but that
might be due to the "culture" (and language) difference.

Biff


Not a bad thing to use different user names and ask the same question (e.g.
SUMPRODUCTIF) over and over?

Can you clarify and elaborate?

Are you referring to culture shift?

I am not sure if we have the same frame of reference.

By "culture" I don't mean ethnicity.

From the dictionary - the set of shared attitudes, values, goals, and
practices that characterizes an institution or organization <a corporate
culture>

In this case, it is forum culture.

What I try to say is that all of a sudden there seems to be a bunch of
people (when in fact there is only one) questioning about the integrity of
formulae posted, Excel, MVP's etc. etc. which is a deviation from the day to
day practice of users helping users solve problem. This is the culture
(shared attitude, values, goals etc.) I am referring to.

I'll do my best to keep quiet in the next few days unless there is a need
for me to clarify. Remember I said I drew too much attention to myself?

Epinn

Not that that's a bad thing!

It's obvious that English isn't their first language and it's hard to
understand them sometimes.

Biff

Thank you, Biff. I was thinking the same thing.

I think we can add

p (see below)
romelsb
to your list.

From: "p" <[email protected]>
Subject: Re: A ? for our Excel Guru's and MVPs
Date: Monday, November 20, 2006 2:21 PM

Bob, remember romelsb? He is the one who was very loud about the TODAY( )
in a report title for the lst half of the month and also for the second half
of the month when Roger and you had a template in mind.

I just don't think that the culture of this forum can transform in such a
short period with *a bunch of people* questioning about ......

What's next?

Epinn

TryHarder
driller
4pinoy
art

All the same person

201.202.129.226 ???

Biff
 
B

Bob Phillips

I don't think it is that innocent. Driller, romelsb, 4pinoy have asked
questions and been particularly obtuse about the response. If it were a
language problem fine, but they do seem to be trying to make some point,
suck people into endless meaningless debates, and generally acting in what I
deem a trolling manner. And p has started posting nonsensical responses.
Even ignoring means that I have wasted my time in reading them.

I will certainly add them to my blacklist. And to reduce chances of being
told I am feeding the trolls, I personally won't get involved in any further
debate.

--

HTH

Bob Phillips

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

Epinn

Bob,

I agree with every single word in your post. I look at the *motive* behind the questions. If you compare the writing skill of romelsb and that of the more recent personnel you can easily tell that the person is pretending that he/she has a language problem.

A few hours ago, Driller posted a question and then within about half an hour p (same person) posted the following under the same thread:

He/she is not just trying to make a point but also to challenge the forum and the MVP's. I see this as a waste of resource. I won't even go near any threads where this person shows up. In other words, I won't be part of his/her game.

Please note that he/she is changing the address.

Epinn

I don't think it is that innocent. Driller, romelsb, 4pinoy have asked
questions and been particularly obtuse about the response. If it were a
language problem fine, but they do seem to be trying to make some point,
suck people into endless meaningless debates, and generally acting in what I
deem a trolling manner. And p has started posting nonsensical responses.
Even ignoring means that I have wasted my time in reading them.

I will certainly add them to my blacklist. And to reduce chances of being
told I am feeding the trolls, I personally won't get involved in any further
debate.

--

HTH

Bob Phillips

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

driller

to Biff, Epinn and Bob Phillips
Guys, cool down and be cautious, you’re trying to be emotional, if you can’t
beat it, sleep on it…Biff, remember about the thread on Datevalue() where you
point out that the result on the function form box will not be correct since
the help files is specific about text input. Then you guys keep on giving
formulas with sumproduct that is not in the helpfiles and function form
box….Now who has the interchangeable attitude under this mental forum ? You
surely have just a taste of your choice…nothing to do about the real forum
purpose which is to simulate the real Microsoft product. Are you a
brainwashing group that try to place the forum on advertisement
purpose?…Making the users to be dependent on other external input –which may
dismay the future users. Next time take care of the wording like
blacklisting another forum member, cause it may shower back to you forever.
Forum challenge is not bad, it’s a mental ability test to assure that we are
on the right track. Eyes wide open ! Focus not on forum member’s background
but rather on your meaningful answer. As simple as that !
Finally, your internal INVESTIGATION on any member’s background and
emphasizing it thru this forum is purely OFFENSIVE cause it may not be the
intent of this forum….I do not know who among us has the real sensitivity to
continue under the domain of this forum. Good luck and may God Bless you!
 
Top