Need help with a formula

Jack N.

=SUMIFs({Results FY24 Location}, [Primary Column]@row, {Delivering Results FY24 Prod},[{Results FY24 Location},{MoHP Results FY24 Range 1},"Aug")

not working - dont know why.

Paul Newcome

Which range houses the numbers you are trying to sum?

Jack N.

 {Delivering Results FY24 Prod}

Paul Newcome

The first range in a SUMIFS is the range that gets summed. Try adjusting your syntax based on the examples near the bottom of the article linked below.

https://help.smartsheet.com/function/sumifs