Sum Functions
 

I need to be able to add up all the data in two rows but only if they
follow two conditions. I have tried to use a COUNTIF but it will only
allow one condition.


Code:
--------------------
=COUNTIF(Database!I:I,"BD", AND(Database!K:K,"Yes"))
--------------------


the database isnt actually a database, rather a tab that I have one my
spreadsheet. Has anyone any suggestions that could heklp me out?? I
need to say how many records are there with this row = BD and this row
= Yes.

Thanks In advance.


--
andyb7901
------------------------------------------------------------------------
andyb7901's Profile: http://www.excelforum.com/member.php...o&userid=25551
View this thread: http://www.excelforum.com/showthread...hreadid=389824

Try:

=SUMPRODUCT((Database!$I$2:$I$10="BD")*(Database!$ K$2:$K$10="Yes"))

Adapt the ranges to suit, but note that we can't use entire col references
in SUMPRODUCT

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"andyb7901" wrote in
message ...

I need to be able to add up all the data in two rows but only if they
follow two conditions. I have tried to use a COUNTIF but it will only
allow one condition.


Code:
--------------------
=COUNTIF(Database!I:I,"BD", AND(Database!K:K,"Yes"))
--------------------


the database isnt actually a database, rather a tab that I have one my
spreadsheet. Has anyone any suggestions that could heklp me out?? I
need to say how many records are there with this row = BD and this row
= Yes.

Thanks In advance.


--
andyb7901
------------------------------------------------------------------------
andyb7901's Profile:
http://www.excelforum.com/member.php...o&userid=25551
View this thread: http://www.excelforum.com/showthread...hreadid=389824