**Placed here because I'm using OpenOffice on a Mac but my boss is using the same file in Excel on Windows, thus it doesn't really fit into PC Software, Mac Software, or Open Source**

Hi all,

I'm trying to do this in a spreadsheet:
count = 0;
If((a range of cells = 818) AND (another range of cells = Y)){
count++;
}

I reckon it can be done with something like COUNTIF, SUMIF, or a combination of one of those with AND and IF...But I can't see what it is...

Thanks,
Ben

=IF(AND(condition 1,condition 2),Answer if Yes, Answer if No)

Thanks Jon, I kept hunting and found this instead:
=SUMPRODUCT(--($Feuil1.$D$4:$D$1987=818);--($Feuil1.$I$4:$I$1987="Y"))