SUMIFS with nested if within criteria ... or something else?

[SSPoulin23]

I have a report showing the monthly breakout of departmental expenditures with many fields (account, department, project code, program, etc). On another tab, there are mini charts for each account code represented within the report. Each mini chart has a number of criteria it looks for on the report - account, Department, Project Code, Program, etc. For the program code, I need the SUMIF to say something like "if there is a program code listed here on Sheet1 in cell C10 on the mini chart, only include that program code in the sum, BUT if there is no program code listed here on Sheet1, include all program codes on the report in the sum" - does that make sense?? Can i accomplish that with a SUMIFS and maybe a nested IF statement? if not, or if there is a better way to accomplish this, please let me know!! THANK YOU!!!

 

[etaf]

yes

=IF ( C10 = a program code listed , sumifs( with just that code) , sumifs(all ))
But i dont know the detail of your data and how structured to provide the code needed or if it will work

maybe a IFERROR () if we are just looking for a value in a list
OR even a countif()

 

[SSPoulin23]

Thank you for replying! I eventually came to that answer too so that's encouraging! thank you so much!