Multi criteria Sum

  • Thread starter Thread starter Salim
  • Start date Start date
S

Salim

I have excel sheet with 3 columns and i want to add cloumn
3 if column 1 is AS and column 2 is bigger than 30/08/2004.
A1:AS B1:30/09/2004 C1:$20000
A2:AT B2:25/10/2004 C2:$10000
A3:AT B3:2/10/2004 C3:$50000
A4:AS B4:20/07/2004 C4:$12000
A5:As B5:15/06/2004 C5:$8000
A6:AT A6:20/03/2004 c6:$5000
I.E EXPECTED ANSWER IS $20000
 
Hi!

Try this:

=SUMPRODUCT(--(rng1="AS"),--(rng2>DATE(2004,8,30)),rng3)

Replace rng1,rng2,rng3 with you named ranges.

Biff
 
Back
Top