Countifs function in vba

[Sugisenthil]

Hi
I have the below formula in excel. It is working good but very slow
So i am planning to put the count if formula in vba code so that i can reduce the slow processing speed
Can any one help me on this
=countifs(sheet1!A1:A300,sheet2!A1,sheet1!B1:B300,">="&today-3)
This the my formula
Where a1:a300 is the list of name and b1:b300 is the dates
Also in sheet2 a1 is the today dat.
Which i need to count how many time a person was complained with in last 3days.
Please help me!!!

[Vikas_Gautam]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Sugisenthil]

I need a vba code for the said formula
Can any one help me!!!

[Sugisenthil]

=countifs(sheet1!A1:A300,sheet2!A1,sheet1!B1:B300,">="&today-3)

[tigertiger]

=countifs(sheet1!A1:A300,sheet2!A1,sheet1!B1:B300,">="&today-3)

this is an example for using directly worksheetfunction

Please Login or Register  to view this content.

on the other hand, you have to manually write an algorithm in this term (use for... if...)

[Sugisenthil]

Not able to get it
Can u elaborate pls

[tigertiger]

in VBA code, you can write this code

Please Login or Register  to view this content.

Then Run the code, you can see the result and may understand how the code executive

[tigertiger]

in VBA code, you can write this code

Please Login or Register  to view this content.

Then Run the code, you can see the result and may understand how the code executive