DRExcel515
Board Regular
- Joined
- Oct 20, 2017
- Messages
- 56
So I have a bunch of column identifiers in column A on Sheet 1 (AVG_EFC_MTY_YR_QT EG). On sheet 2 I have the same column identifiers, except that they go across starting in A1 through IN1 and have data below them in the columns. What I wanted to do on sheet 1 in column B is say go and count all the actual populated data in this column on sheet 2 and exclude if the value is equal to (null). Here is the formula I was trying to build but doesn't seem to work. Any help would be much appreciated!
Thanks,
COUNTIFS(INDEX(Sheet2!1:1,MATCH(Sheet1!$A2,Sheet2!1:1,0)),Sheet1!$A2,Table1,"<>(null)")
Thanks,
COUNTIFS(INDEX(Sheet2!1:1,MATCH(Sheet1!$A2,Sheet2!1:1,0)),Sheet1!$A2,Table1,"<>(null)")