[Solved] Count in Excel using macro

countifs("E:E", "jasper","G:G","S") will give you number of instances of jasper with S as status, and similarly
countifs("E:E", "jasper","G:G","A") will give you number of instances of jasper with A as status