| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste formula
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste formula
=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) "Bobby" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste formula
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. Bobby wrote: 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! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste formula
Im sorry---I would like to do this through macro.
"Bobby" wrote: 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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste formula
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) "Bobby" wrote in message ... Im sorry---I would like to do this through macro. "Bobby" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste Formula | Excel Discussion (Misc queries) | |||
| Paste Value Formula | Excel Discussion (Misc queries) | |||
| Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
| formula cut and paste | Excel Worksheet Functions | |||
| Paste Formula | Excel Discussion (Misc queries) | |||
Linear Mode
