Sumif with two criteria

Giganews Newsgroups
Subject: Sumif with two criteria
Posted by:  danper…@joannstores.com (anonymo…@discussions.microsoft.com)
Date: Thu, 30 Oct 2003

I need to add column c if column a and column b both meet
my criteria.

example
    A      B      C
1  X      Y      3
2  S      Y      1
3  X      Y      2
4  X      F      3
5  F      Y      3

X AND Y          5

Replies