Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 2 down vote accepted

I don't have the Mac version, but I imagine it's similar to PC version. If so, you can use the sumif function like this:-

=SUMIF(D3:D31,"Status Update",H3:H31)

If you have further conditions to use, then you could look into using array formulas to create products of booleans like this:

{=SUM((D3:D31="Status Update")*(H3:H31))}

On a PC you have to enter the array formula by pressing Ctrl-Shift Enter. Not sure of the key equivalent on Mac but I'm sure there is one...

share|improve this answer
Yes that worked. I totally forgot about SUMIF, a bit rusty. Thanks! – user1470242 Dec 7 '12 at 20:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.