Help Required on VBA COUNTIFS Formula using multiple Criteria

**Ayubalia1** · 12-30-2018, 01:42 PM

Hi All,

Please anyone help me on below request.

I'm working on Automation Dashboard Please help on below Code

Please Login or Register  to view this content.

Last Criteria Range("J1") is the Dropdown value
If the ("D1") value is "Internal" then it should calculate only *ABC LTD* from Worksheets("CSAT Data").Range("B:B")
If the ("D1") value is "External" then it should calculate other then *ABC LTD* from Worksheets("CSAT Data").Range("B:B")
If the ("D1") value is "Overall" then it should calculate both above criteria

I truly appreciate anyone's help
Suggest me if I can use Arrays or if I can Declare multiple Variables or I can Use "If then"

Many Thanks you for help in Advance

**Richard Buttrey** · 12-30-2018, 05:22 PM

Hi and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.