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

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

 

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