#SPILL!

[luisitocarrion1900]

I have the below formula but when I paste it, it gives #SPILLS!

=COUNTIFS(PYD_DATA[Region],{"AF","EAP","EUR","NEA","SCA","WHA"},PYD_DATA[Qtr Rptd],"Q1")

 

[jasonb75]

Do you want the result in a single cell or a cell for each criteria in the array? Perhaps

=SUM(COUNTIFS(PYD_DATA[Region],{"AF","EAP","EUR","NEA","SCA","WHA"},PYD_DATA[Qtr Rptd],"Q1"))

How to correct a #SPILL! error - Microsoft Support

How to correct a #SPILL error in Excel (when a formula returns multiple results and cannot return them to the grid).

support.microsoft.com

 

[luisitocarrion1900]

That works Perfectly, Thank you so much