I am trying to apply "COUNTIF" according to the dynamic ranges of column(B) and count how many of the same "rates" are applied.
For exmple,
H22 formula is COUNTIF(E22:E24, F22)
H25 formula is COUNTIF(E25:E30, F25)
I do not have to have "yes" or "no", but need some help on vertical countif according to column B. I know how to do this from pivot/subtotal but I need this for VBA. Please advise. Thank you!
EDIT: mod: html deleted as messing with the post. Post only representative snapshots of your data.
For exmple,
H22 formula is COUNTIF(E22:E24, F22)
H25 formula is COUNTIF(E25:E30, F25)
I do not have to have "yes" or "no", but need some help on vertical countif according to column B. I know how to do this from pivot/subtotal but I need this for VBA. Please advise. Thank you!
EDIT: mod: html deleted as messing with the post. Post only representative snapshots of your data.