If a cell equals 0, complete a sumifs using and/or

[blaix]

I am sure this is far more straightforward than I am making it out to be, but I am simply trying to produce one column (Column L) that -

• Will sum the total invoiced to a client YTD (Data in another sheet called Invoicing)
• If that total is 0, I want it to assume $1500 if data in column A says Business or $800 if data in column A says Individual.

How it currently looks:

Entity Type	Client Name	2023 Invoice
Business	ABC Co.	2600
Business	We Do Business Stuff	0
Individual	Bob McBobberson	5125
Individual	Shooty McFace	0

How I'd like it to return:

Entity Type	Client Name	2023 Invoice
Business	ABC Co.	2600
Business	We Do Business Stuff	1500
Individual	Bob McBobberson	5125
Individual	Shooty McFace	800

I may need to use a helper column where 2023 Invoice returns what has been paid or 0 and another column of IF 0 then, but I can get a formula to partially work and return 1500 if '2023 Invoice' is blank and A is Business, but can't figure out how to write it for both or I can figure out how to calc 1500 for biz, 800 for individual, but not how to overwrite if something is already in '2023 Invoice' column.

 

[blaix]

Nevermind, I should have just stuck it out a bit longer... = IFS(L22<>0,L22,AND(L22=0,A22="Business"),1500,OR(L22=0,A22="Business"),800)