Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CountIf and Sum Help???
Within a macro I am trying to add 2 formulas to the bottom row of my worksheet. 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? 01 150080380549 0000718649 000000095556 01 150080380549 0000718650 000000012000 01 150080380549 0000718651 000000002080 01 150080380549 0000718652 000000002912 02 150080380549 ???? ??? ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select ActiveCell.Value = "02" ActiveCell.Offset(0, 1) = "150080380549" ActiveCell.Offset(0, 2) = -- rstanger ------------------------------------------------------------------------ rstanger's Profile: http://www.excelforum.com/member.php...o&userid=27811 View this thread: http://www.excelforum.com/showthread...hreadid=473197 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|