How SUM come here? {=SUM((Rng1="Car")*(Rng2="names")*(Profits))}

D

dindigul

When looking at SUM's syntax it says (number1, number2 ...). How does one
figure out that even these type of statements are possible? Does the Manual
list all such possibilities?
 
P

Peo Sjoblom

Try

=SUMPRODUCT(--(Rng1="Car"),--(Rng2="names"),Profits)

There are no manuals in Excel anymore so I assume you mean help, I believe
97 was the last one with a manual
It was also the last one with decent help
 
T

T. Valko

How does one figure out that even these type of statements are possible?

Experience, trial and error, and seeing someone else using it (reading about
it)!

Biff
 
Top