I am Using Excel 2011 for Mac and am having a hard time figuring out a way to return some data that I need.
I have a sheet with a table, column D is "Type" and column H has numbers. I want one cell to show to total of values in Column H given that the Type is "Status Update". I took a shot with
=IF('Key metrics'!D3:D31="Status Update",SUM('Key metrics'!H3:H31),0)
but that didn't work. Any suggestions?