Re: Question on conditional formulas with text

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 02/10/04 

Date: Tue, 10 Feb 2004 10:05:52 +0100

Hi Patrick
one way:
=SUMPRODUC((A1:A1000="a")*(B1:B1000="x"))

Frank

Patrick wrote:
> I have a scenario that I cannot figure out. I want to
> find the total number of entries in one column based on
> entries in another column. Here is an example:
>
> column 1: column 2:
> 1 a 1 x
> 2 a 2 x
> 3 b 3 x
> 4 b 4 x
> 5 5 y
> 6 a 6 x
>
> I want to add all the column 2 entries with "x" where the
> corresponding entry in column 1 is "a". So the answer I
> am looking for is 3.
>
> Thanks,
> Patrick

Quantcast