Paste formula

B

Bobby

Hello
I would like to paste this formula into H2:AE2
=SUMPRODUCT(--($F$3:$F$500="7-F"),--($G$3:$G$500="A"),$H$3:$H$500)
Where the critera refs are static and the sum range follows the column
ie.
H2=SUMPRODUCT(--($F$3:$F$500="7-F"),--($G$3:$G$500="A"),$H$3:$H$500)
I2=SUMPRODUCT(--($F$3:$F$500="7-F"),--($G$3:$G$500="A"),$i$3:$i$500)
J2=SUMPRODUCT(--($F$3:$F$500="7-F"),--($G$3:$G$500="A"),$j$3:$j$500)

Thanks!
 
B

Bob Phillips

=SUMPRODUCT(--($F$3:$F$500="7-F"),--($G$3:$G$500="A"),H$3:H$500)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

Dave Peterson

Try dropping the $ signs around $H$3:$H$500:

=SUMPRODUCT(--($F$3:$F$500="7-F"),--($G$3:$G$500="A"),H$3:H$500)

The $H says to not change that column reference when you copy the formula.
 
B

Bob Phillips

Range("H2").Formula =
"=SUMPRODUCT(--($F$3:$F$500=""7-F""),--($G$3:$G$500=""A""),H$3:H$500)"
Range("H2").Autofill Range("H2:J2")


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top