AnsweredAssumed Answered

Sumif Function

Question asked by CraigRozelle on Jan 25, 2012
Latest reply on Jan 25, 2012 by philmodjunk

Title

Sumif Function

Post

I have a table with two fields: stories and area. The data looks like the following:

Stories     Area

    1         500

    1         400

    2         250

I need to summarize the areas by stories in two fields in a related table like this:

Stories     Area

    1         900

    2         250

In a spreadsheet, I would simply use a sumif calculation. Is there a similar function or a work-around to accomplish this?

Outcomes