If & Array

[Guest]

What would my formula look like if I had 2 conditions that needed to be met
and then for any that met that condition to count those instances, in this
case it is all text entries.

Thanks
Bec

 

[Peo Sjoblom]

What are the conditions?

=SUMPRODUCT(--(ISTEXT(Range1)),--(Range2=1),--(Range3=2))

as an example but you need to be more specific

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[T. Valko]

Do you mean something like this:

...........A..........B
1........D..........B
2........X..........Y
3........X..........C
4........C..........X
5........X..........Y

Count instances where column A = X and the same row in column B = Y ?

=SUMPRODUCT(--(A1:A5="X"),--(B1:B5="Y"))

The result is 2.

A better way to do this is to use cells to hold the criteria:

D1 = X
E1 = Y

=SUMPRODUCT(--(A1:A5=D1),--(B1:B5=E1))

 

[Guest]

It worked a treat on my test page but I'm having trouble with the 'real'
spreadsheet, maybe because I'm using validation lists?

I'll keep going, but thanks so much for the help!!

 

[T. Valko]

Try explaining what you're wanting to do in more specific detail. Your
original post was really vague and I was just guessing at what you wanted.