Nope.

maybe...

=SUMPRODUCT(--(Sheet1!$A$1:$A$4="A"),--($B$1:$B$4=4))
or
=SUMPRODUCT(--(Sheet1!$A$1:$A$4="A"),--(sheet1!$B$1:$B$4=4))

depending on where your data is.

If it still doesn't work, it's best to copy the formula from the formula bar and
paste it into the newsgroup post. Then typing errors won't be added.

srain001 wrote:

Hi,

Thanx. I had the () at the right spot. My post was a typo....!! In any
case, I'm still not getting a proper count. I should have mentionned that
the values I'm counting are in another worksheet. Here's what I have:
=SUMPRODUCT(--(Sheet1$A$1:$A$4="A"),--($B$1:$B$4=4)

Does this make any sense?

Steph

"Dave Peterson" wrote:

Watch your ()'s:

=SUMPRODUCT(--($A$1:$A$4="A"),--($B$1:$B$4=4))

If this doesn't help, look for leading or trailing spaces in the values in
column A. And see if the values in column B are really numbers. You can use
=isnumber(b4) to see true/false.


srain001 wrote:

Hi,

I am trying to create a formula to count information located in two separate
columns but appear in the same row. For example:

Column A Column B
A 1
B 2
C 3
D 4

What I'm trying to do is count every instance that "A" appears in the same
row as "4" at any given time. The current formula I'm working with is
=SUMPRODUCT(--$A$1:$A$4="A"),--($B$1:$B$4=4))

However, something must be wrong because I keep getting a count of 0 even
though I'm reference the right column and range.

Hope anyone can help!

Srain

--

Dave Peterson


--

Dave Peterson