ActiveCell.Offset(0, 2).Formula = "=SUMIF(....)"


--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Rick" wrote in message
...
Within a macro I am trying to add 2 formulas to the bottom row of my
worksheet (The column length will be changing each time). The code is
below
and has allowed me to add static data. Now I need to do a count or countif
(or something else) for column C that will give
me the total number of rows that are "01". And for the final column I want
to do a sum.

Can anyone help?

Thank You All!

SAMPLE CELLS
01 150080380549 0000718649 000000095556
01 150080380549 0000718650 000000012000
01 150080380549 0000718651 000000002080
01 150080380549 0000718652 000000002912
02 150080380549 ???? ???

Existing Formula

ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select
ActiveCell.Value = "02"
ActiveCell.Offset(0, 1) = "150080380549"
ActiveCell.Offset(0, 2) =