fuctions with multiple conditions


Posted by Dave on January 23, 2002 12:18 PM

i'm sure this is a repeated question, but i was wondering if someone could coach me through counting values in a column based on whether certain criteria were met in two (or more) other columns. basically, i have a table where each row represents a record. i want to count all the records that satisfy conditions in two of the fields.

i've been trying to do an array function like this:

count(if(and(a1:a10=1,b1:b10>date(2000,12,31)),a1:a10)

this will not give me an error, but i won't get the right answer either. any advice? thanks.

Posted by Mark W. on January 23, 2002 12:29 PM

=SUMPRODUCT((A1:A10=1)+0,(B1:B10>DATE(2000,12,31))+0) [nt]



Posted by david on January 23, 2002 3:45 PM

thanks for the help!

thanks for the help!