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

  • Thread starter Thread starter dindigul
  • Start date Start date
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?
 
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
 
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
 
Back
Top