Unable to get SUMIFS to work
Hello, I am trying to use the SUMIFS function to total up the expenditure data from an imported file. I want the cell to total all of the expenditures for a particular district based on fund type, but am not successful. I am wanting to pull the data from another sheet called "Allocations" which has all of the information I need to tabulate. Additionally, I want the cell to bring up the values that meet the criteria below: give me the expenditures for district 1 (Eureka), PEC Class 4020, Object Class 0199, and fall in fund 0042. I keep getting an #invalid argument using the formula shown.