Help for Extract the no of count for same value with two different criteria in VBA

Hi Team,

I want to extract the no of count with two different criteria with same value

I have tried with countifs formula but i can extract only first row information not result come as expected.

I need help for VBA code based extraction

I have attached the excel sheet for your reference

in sheet1 have some information like A to F (no specific limit)

i want to count the value based on F row (gnd, signal, power etc) with respect to column A, but A row having two different values example name of D1 & B1

result should be GND value having extracted count of D1 and B1 separately.
Result should be comes in I:J:K column, I column value is either i can type or copy paste from F column.

Please do the needful.

In J6 try this formula and drag it across ot K6

Formula:

Please Login or Register  to view this content.