hello :
I would ask you how can i write code vba for following:
I would to count within range(g3:g1000) which contain certain date and count range(p3
1000) which contain the "4130"
and put the results in cells in another sheets
I wrot this but don't work:
if range("g3:g1000")=date and range("p3
1000")="4130"
cells(2,2)=count(????) how to write this![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
I would ask you how can i write code vba for following:
I would to count within range(g3:g1000) which contain certain date and count range(p3
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
and put the results in cells in another sheets
I wrot this but don't work:
if range("g3:g1000")=date and range("p3
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
cells(2,2)=count(????) how to write this
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)