Sum Functions

A

andyb7901

I need to be able to add up all the data in two rows but only if the
follow two conditions. I have tried to use a COUNTIF but it will onl
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 m
spreadsheet. Has anyone any suggestions that could heklp me out??
need to say how many records are there with this row = BD and this ro
= Yes.

Thanks In advance
 
M

Max

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
 
Top