Sum based on status and Month

HZAR

Hi

Screenshot 2024-05-14 013339.png

I have the input and output screenshot as attach. How can I pull the formula to gather the sum of $ based on status for each month. Need some guidance. Thanks

Mark.poole

@HZAR

=Sumifs({$$ Ref},{Month number Ref},[Month Number Column]@row,{Status Ref},"Open")

Repeat for Closed, Cancel, and Rejected in their respective columns

Mark.poole

@HZAR

=Sumifs({$$ Ref},{Month number Ref},[Month Number Column]@row,{Status Ref},"Open")

Repeat for Closed, Cancel, and Rejected in their respective columns

HZAR

Hi Mark

Thanks for the input. It works :)

Mark.poole

Your very welcome