Forum Discussion
Countifs and sumifs
Hi Guys,
Please help me to resolve issue which is attached here in screenshot.
Actually i want to count and sum particular column text where the required date is mentioned. I used sum and countits array formula but its not working.
1 Reply
Rfire777 As per your screenshot, there appears to be a bracket in the wrong place with the INDEX / MATCH combo...
Incorrect Syntax
The correct syntax should be:
=ARRAYFORMULA(SUM(COUNTIFS(All_Premium!AP:AP, A3&B3, INDEX(All_Premium!AD:AJ, 0, MATCH($O$2, All_Premium!AD1:AJ1, 0)), {"*cnp*","*cnc*"})))
