Thread: HELP
View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

=SUMPRODUCT(--(rng1="value"),--(rng2=number),rng3)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dan" wrote in message
...
I am trying to make a sum... it need to do what a SUMIF does but it needs

to
ask 2 questions to get a answer