Multiple criteria formula needed

[jqadri]

So, the goal is to find 3 criteria within column D, if column P ( month ) matchs another column on a different tab, count the number on column J


The old formula that was used is, "=IFERROR(IF(OR($C5923="Renewal",$C5923="Client Implementation"),0,J5923),"-")" since our CRM has been updated, this doesnt work anymore..

I feel like I'm thinking too much into it and there is a simplier way to solve this..

Any suggestions?

Thank you inadvance!

 

[shg]

That formula doesn't reference column P ...

 

[jqadri]

That formula doesn't reference column P ...

Correct, that was an old formula that was used before our CRM has been updated. Sorry, I wasn't as clear! This is a frame of reference of what was used previously. However, due to the changes, I think it's alot more complicated now.

3 criteria needs to be found in column D, and as long as column P matches another tabs column, we can count column "J".

 

[shg]

I'm pretty hard pressed to guess what you're trying to do from the information you're providing. How about an example?

 

[jqadri]

I'm pretty hard pressed to guess what you're trying to do from the information you're providing. How about an example?

2 tables represent different tabs (the "current month in reference) would be used as a reference cell within another tab for current month in question.. I hope this helps!

CaseSubtype	# of plans	month built	current month in reference(on diff. tab)
client -JIT	3	May 2018	May 2018
client - Child	10	May 2018	May 2018

<tbody>
</tbody>

	Number of Plans for Month
Team A	13

<tbody>
</tbody>