I used this array formula in my macro to add all the cells that contain
blank in column F; however, it is not calculating ... should I use something
else?

=SUM((Sheet1!B2:B250="WARRANT")*(Sheet1!F2:F250=" ")*(Sheet1!C2:C250))

my code:

Worksheets("Sheet2").Range("b14").FormulaArray = _
"=SUM((Sheet1!B2:B250=""WARRANT"")*(Sheet1!F2:F250 =""
"")*(Sheet1!C2:C250))"

Use

Sheet1!F2:F250=""

Not

Sheet1!F2:F250=" "

HTH
Jason
Atlanta, GA

-----Original Message-----
I used this array formula in my macro to add all the
cells that contain
blank in column F; however, it is not calculating ...
should I use something
else?

=SUM((Sheet1!B2:B250="WARRANT")*(Sheet1!F2:F250 =" ")*
(Sheet1!C2:C250))

my code:

Worksheets("Sheet2").Range("b14").FormulaArray = _
"=SUM((Sheet1!B2:B250=""WARRANT"")*(Sheet1!F2:F250 =""
"")*(Sheet1!C2:C250))"



.

That is not blanki but space. Use

=SUM((Sheet1!B2:B250="WARRANT")*(Sheet1!F2:F250="" )*(Sheet1!C2:C250))


--

HTH

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


"Annette" wrote in message
...
I used this array formula in my macro to add all the cells that contain
blank in column F; however, it is not calculating ... should I use
something
else?

=SUM((Sheet1!B2:B250="WARRANT")*(Sheet1!F2:F250=" ")*(Sheet1!C2:C250))

my code:

Worksheets("Sheet2").Range("b14").FormulaArray = _
"=SUM((Sheet1!B2:B250=""WARRANT"")*(Sheet1!F2:F250 =""
"")*(Sheet1!C2:C250))"