Sum with conditions

Options
mikeng
mikeng Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

Hi all,

I'm having trouble with the sum function. I have the reference module [A] as below:

Module [A].JPG

Then I need to sum in Module [B] that only select the "SGA" element in "P&L Total" (which is a list) but I can't. The line item needs to insert the formula is "SGA" in the image below:

Module [B].JPG

 

I've tried all sum, select, lookup, select&sum to insert the ".SGA" but the formula still doesn't work. Please help!

 

Thanks very much!

Best regards,

Mike

Tagged:

Categories