countif
I would like to incorporate the formula COUNTIF(A1:A472,"Zanesville") in my
macro Zanesville would be filled in from the last row of data in the row the formula appears I thought something like (which doesn't work): ..Cells(i, "E").Formula = "=countif(A1:A" & LastRow & """" & _ .Cells(i - 1, "A").Value & """))" |
countif
Not sure about how where you say "Zanesville" will be found works out with
your .Cells(i-1,"A").Value reference, but assuming your attempted formula is using the correct referenced parts, see if this works for you... ..Cells(i, "E").Formula = "=COUNTIF(A1:A" & LastRow & ",""" & _ .Cells(i - 1, "A").Value & """)" -- Rick (MVP - Excel) "Bob" wrote in message ... I would like to incorporate the formula COUNTIF(A1:A472,"Zanesville") in my macro Zanesville would be filled in from the last row of data in the row the formula appears I thought something like (which doesn't work): .Cells(i, "E").Formula = "=countif(A1:A" & LastRow & """" & _ .Cells(i - 1, "A").Value & """))" |
countif
works great! Thank you.
anyway I could put the word "Total" in the cell left of the formula (formula is in column E and the word "Total would be in colmn D)? "Rick Rothstein" wrote: Not sure about how where you say "Zanesville" will be found works out with your .Cells(i-1,"A").Value reference, but assuming your attempted formula is using the correct referenced parts, see if this works for you... ..Cells(i, "E").Formula = "=COUNTIF(A1:A" & LastRow & ",""" & _ .Cells(i - 1, "A").Value & """)" -- Rick (MVP - Excel) "Bob" wrote in message ... I would like to incorporate the formula COUNTIF(A1:A472,"Zanesville") in my macro Zanesville would be filled in from the last row of data in the row the formula appears I thought something like (which doesn't work): .Cells(i, "E").Formula = "=countif(A1:A" & LastRow & """" & _ .Cells(i - 1, "A").Value & """))" |
countif
Answered my own question with:
Cells(i, "D").Formula = "Total" "Bob" wrote: I would like to incorporate the formula COUNTIF(A1:A472,"Zanesville") in my macro Zanesville would be filled in from the last row of data in the row the formula appears I thought something like (which doesn't work): .Cells(i, "E").Formula = "=countif(A1:A" & LastRow & """" & _ .Cells(i - 1, "A").Value & """))" |
countif
anyway I could put the word "Total" in the cell left of the formula
(formula is in column E and the word "Total would be in colmn D)? I do not understand the question you are asking here. Can you rephrase it and maybe show us an example? -- Rick (MVP - Excel) |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com