# Dsum or Sumif Help!!!

G

#### Guest

I have spreadsheet which has 3 columns

A B C
1 Acct No Account Amount
2 D12 XX1 732.50
3 XX2 10,451.12
4 D13 XX3 52,741.51
5 D14 XX4 289.86
6 XX5 7,654.12
7 D15 XX6 95,785.32
8 XX7 2,367.49
9 XX8 32,965.74
10 D16 XX9 65,874.36

What i would like to do is produce 2 diferent sum amount based on a diferent
criteria.

firstly: I want to sum column C only the amounts where there is no account
no.
basically =sumif(a2:c10, "if the corresponding value in column a is
blank",c2:c10)

secondly: sum the amounts in column c in between Â£5,000 and Â£50,000

Hervinder

G

#### Guest

=SUMPRODUCT(--(A2:A10=""),C2:C10)

=SUMIF(C2:C10,"<50000")-SUMIF(C2:C10,"<5000")

G

#### Guest

=SUMPRODUCT(--(A2:A10=""),--(C2:C10))

=SUMPRODUCT(--(C2:C10>=5000),--(C2:C10<=50000)*(C2:C10))

B

#### Bob Phillips

=SUMIF(A2:A10,"",C2:C10)

=SUMPROUCT(--(C2:C10>=5000),--SUMIF(C2:C10<=50000),C2:C10)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)