Forum Discussion
SUDHAKAR-FRONTIER
Feb 10, 2021Brass Contributor
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
1 Reply
- peteryac60Iron Contributor
Can you please attach your file and explain what you would like to happen.
thanks
Peter