Countif date range AND Countif col in same row isnotblank.

[tnesseth]

Long time Reader First Time Pleader -

Guy I hope none has asked this same question exactly.
I have a 1400 fields in db object- i need the count of fields usage from the fields inception date.

Table one: Column A is the field Name then Created date field and then countif range from table two (all the records)

Field Name	Create Date	Usage from create
ABM_TIER_1__C	11/4/2020	1216
ACCOUNTID	2/11/2021	n/a
ACCOUNT_BU_VS_OPP_BU_MISMATCH__C	1/6/2020	5673

Table two (all the records and each fields contents)

ABM_TIER_1__C	ACCOUNTID	ACCOUNTID
4/16/2004​	T06:35:48.000Z	FALSE​
4/16/2004​	T06:35:48.000Z	FALSE​
4/16/2004​	T06:35:48.000Z	FALSE​

essentially i need a count of fields populated on or after their respective created dates.
so i can thoughtfully argue which fields can burn in eternal h..... you get the gist

You are true heroes!

 

[RoryA]

Do you mean this, in C2, based on your picture in post 6:

=SUMIF($E$2:$E$100,">"&B2,INDEX($F$2:$I$100,0,MATCH(A2,$F$1:$I$1,0)))

 

[tnesseth]

Do you mean this, in C2, based on your picture in post 6:

=SUMIF($E$2:$E$100,">"&B2,INDEX($F$2:$I$100,0,MATCH(A2,$F$1:$I$1,0)))

YES!!! THANK YOU SO MUCH!!!