question

ZayarLwin-1669 avatar image
0 Votes"
ZayarLwin-1669 asked Anbuselvam answered

VBA Code For CountIF Formula Util the Last Row We Used

Dear Sir,
I am try to count the cell data base on Column C & D. Fortunately , I found the CountIf Formula for this. I am using VBA for my test and I want to write it in VBA Code. I want to try the code utile the last used Row cause I held many amount of data. Thanks you so much.108840-countif.png


office-vba-devoffice-scripts-excel-dev
countif.png (7.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZayarLwin-1669 avatar image ZayarLwin-1669 ·

Sorry I give wrong Formula.
Formula = =COUNTIFS($C$10:$C$14,C10,$D$10:$D$14,D10)

0 Votes 0 ·

1 Answer

Anbuselvam avatar image
0 Votes"
Anbuselvam answered

Column "C" and "D" You have a data from row 2 to 7. Then how the formula analyse C10, C14 and D10, D14 Datas?

Attach a sample file or link with exact explanation of what you want?

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.