Hello,
I am trying to sum one column but need to pull critera from two different
columns. Does anybody have any suggestions?

Here's an example.

Coulmn A has property codes 33-40-41 etc..., coulmn B has the dollar amount
and coulmn C has if it is an F=fixed asset or N=non fixed asset. I need to
sum the dollar amounts in column B only if coulmn A = 33 and coulmn C=F (see
below) My total should be $1300.00. Is there a way without using a pivot
table?

A B C
33 50.55 N
40 100.25 F
40 200.00 N
33 800.00 F
33 500.00 F

Try this:

=SUMPRODUCT(--(A2:A6=33),--(C2:C6="F"),B2:B6)

Better to use cells to hold the crieria:

E2 = 33
F2 = F

=SUMPRODUCT(--(A2:A6=E2),--(C2:C6=F2),B2:B6)

--
Biff
Microsoft Excel MVP


"jjohnsonofduluthMN" wrote in
message ...
Hello,
I am trying to sum one column but need to pull critera from two different
columns. Does anybody have any suggestions?

Here's an example.

Coulmn A has property codes 33-40-41 etc..., coulmn B has the dollar
amount
and coulmn C has if it is an F=fixed asset or N=non fixed asset. I need
to
sum the dollar amounts in column B only if coulmn A = 33 and coulmn C=F
(see
below) My total should be $1300.00. Is there a way without using a pivot
table?

A B C
33 50.55 N
40 100.25 F
40 200.00 N
33 800.00 F
33 500.00 F

Anytime you need to address multiple criteria, consider using =SUMPRODUCT().

It's like SUMIF() on steriods.

=SUMPRODUCT((A1:A10=33)*(C1:C10="F"),(B1:B10))

For more information:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Gary''s Student - gsnu200843


"jjohnsonofduluthMN" wrote:

Hello,
I am trying to sum one column but need to pull critera from two different
columns. Does anybody have any suggestions?

Here's an example.

Coulmn A has property codes 33-40-41 etc..., coulmn B has the dollar amount
and coulmn C has if it is an F=fixed asset or N=non fixed asset. I need to
sum the dollar amounts in column B only if coulmn A = 33 and coulmn C=F (see
below) My total should be $1300.00. Is there a way without using a pivot
table?

A B C
33 50.55 N
40 100.25 F
40 200.00 N
33 800.00 F
33 500.00 F

Hi

Try
=Sumproduct($A$1:$A$100=33)*($C$1:$C$100="F")8$B$1 :$B$100)


--
Roger Govier
------------------------------------------------------------------------
Roger Govier's Profile: http://www.thecodecage.com/forumz/member.php?userid=81
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82545