Forum Discussion

SUDHAKAR-FRONTIER's avatar
SUDHAKAR-FRONTIER
Brass Contributor
Feb 10, 2021

excel spill ERROR

Hi Team,

 

Kindly help me for this below error,

 

=IF(NOT(SAP!AL2:AL12694="AP CREDIT NOTE"), SUMIFS(SAP!X:X,SAP!G:G,">=01-11-2020",SAP!G:G,"<=31-10-2021",SAP!U:U,"HP"))

 

while i am trying the IF function in account column, I am getting the SPILL error(spill too big)

 

account type (ap credit note, ap invoice, GRN, PO)this are the option available, I want to except "AP credit note" all others type ,

sumifs working fine..

 

If i use IF() condition then i am getting error

and  if(not(SAP!AL2="AP CREDIT NOTE")) its working but not particular account its reflecting all account type values so 

 

Kindly help me

 

 

 

Resources