Function Help! (Count/Vlookup/IF)

[AL789]

Hi everyone!
I'm hoping I can get some help writing a function. I need something that can look up a project number in another tab and count associated data from other columns to bring into the new tab. I attached a sample file of what my data looks like and how I want the resulting formula to be displayed.

Any ideas?

[#2]

@AL789 

=SUM(IF(ISEVEN(COLUMN(OFFSET(Table1[[#Headers],[Project '#]],MATCH(A2,Table1[Project '#],0),1,1,COUNTA(Data!$1:$1)-1))),IF(OFFSET(Table1[[#Headers],[Project '#]],MATCH(A2,Table1[Project '#],0),1,1,COUNTA(Data!$1:$1)-1)<>"",1,0)))

Ctrl+Shift+Enter

[#3 · Accepted solution]

@AL789 

As variant

=IFNA(COUNTIFS(Table1[#Headers],"*Name",INDEX(Table1,MATCH($A2,Table1[Project  '#],0),),"<>"),"")

[#4]

@AL789 

BTW if this is a very large data set, I'd recommend looking into PowerQuery.

This is you data after I "un-pivot" it in Power Query and pivot it for the results: