Blank cell criteria

[Annette]

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))"

 

[Jason Morin]

Use

Sheet1!F2:F250=""

Not

Sheet1!F2:F250=" "

HTH
Jason
Atlanta, GA

 

[Bob Phillips]

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)