Ok... I figured out what the problem is.

Both you and Dave Peterson are correct the formula in the frisbee column is
not the problem.

The problem is that there are several cells in the frisbee column where the
formula in the cell has returned a #N/A . The formula that we have been
working to create does not like this #N/A.

Do you have any ideas on how to work around the #N/A ?



"T. Valko" wrote:

What does the formula that returns frisbee look like?

If the SUMPRODUCT isn't counting "frisbee" then that sounds like the other
formula returns something along with frisbee, like maybe some kind of unseen
whitespace character.

Try one of these:

=SUMPRODUCT(--(Master!E3:E800="Blue"),--(TRIM(Master!I3:I800)="frisbee"))

=SUMPRODUCT(--(Master!E3:E800="Blue"),--(ISNUMBER(SEARCH("frisbee",Master!I3:I800))))

--
Biff
Microsoft Excel MVP


"ksean" wrote in message
...
Hello T. Vallko, Thanks for all your help so far, the link you provided
was
very helpful.

I was able to get this formula to work

=SUMPRODUCT((Master!E3:E800="Blue")*(Master!I3:I80 0="frisbee"))

But now I have run into another problem (will it never end??).

When "frisbee" is the result of another formula the SUMPRODUCT formula
doesn't work. How can I get the SUMPRODUCT formula to work based on the
value of "frisbee" when frisbee is the result of a formula?

Thanks


"ksean" wrote:

I used your exact formula and it didn't work then I assumed the -- meant
needed to add in where the -- was

1st =SUMPRODUCT(--(Master!D1:D10="blue"),--(Master!E1:E10="frisbee"))
2nd
=SUMPRODUCT((countif(Master!D1:D10="blue")),(count if(Master!E1:E10="frisbee")))

Kerry


"T. Valko" wrote:

I can't get your formula to work

Kind of vague. What exactly does that mean? You get an error? You get
the
wrong result? You don't get any result? Your hard drive crashed?

Post the *exact* formula you tried.

what does the -- stand for?

See this:

http://xldynamic.com/source/xld.SUMPRODUCT.html

--
Biff
Microsoft Excel MVP


"ksean" wrote in message
...
I can't get your formula to work as you have shown it, in your formula
what
does the -- stand for? I am still missing something!



"T. Valko" wrote:

Try this...

=SUMPRODUCT(--(Master!D1:D10="blue"),--(Master!E1:E10="frisbee"))

Better to use cells to hold the criteria:

A1 = blue
B1 = frisbee

=SUMPRODUCT(--(Master!D1:D10=A1),--(Master!E1:E10=B1))

--
Biff
Microsoft Excel MVP


"ksean" wrote in message
...
Thanks it worked great however now I need to expand the search
across 2
columns on a different sheet.

For example:
I need cell B5 on sheet 'stock' to tell me how many times column D
on
sheet
'Master' displays "blue" and column E displays "frisbee". I am
trying
to
determine how many times "blue" and "frisbee" appear on the same
row
side
by
side.

Thanks,
Kerry



"T. Valko" wrote:

Try this:

=COUNTIF(A1:A300,"A1")

--
Biff
Microsoft Excel MVP


"ksean" wrote in message
...
Is there a way to use a formula to determine how many times an
alphanumeric
value is used in a column of cells.

For example a column consisting of 300 cells that have one of
the
folloing
notations in each cell "A1, A2, B1, B2, B3, C1, C2 or C3".

Can a formula be used to determine how many times A2 appears in
the
column
if so what formula would I use?

Can a formula be used to determine how many times A1 or B3 or
C2
appears
in
the column if so what formula would I use?


.



.



.



.