Is it possible to Sum based off of status change in a different column?

Brendan Ginns

For instance,

if I had two columns, one is a number value and the other is a status value. if the status value is red and i wanted to sum just the values of the red statuses, is this possible by using a SUMIF Function.

Thanks,

Brendan

Paul Newcome

It would look something along the lines of...

=SUMIFS([Number Column]:[Number Column], [Status Column]:[Status Column], "Red")