If & Array
 

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

If & Array
 

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)


"Bec" wrote in message
...
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

If & Array
 

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))

--
Biff
Microsoft Excel MVP


"Bec" wrote in message
...
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

If & Array
 

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" wrote:

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))

--
Biff
Microsoft Excel MVP


"Bec" wrote in message
...
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

If & Array
 

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.

--
Biff
Microsoft Excel MVP


"Bec" wrote in message
...
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" wrote:

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))

--
Biff
Microsoft Excel MVP


"Bec" wrote in message
...
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