THANK YOU THANK YOU THANK YOU. You have no clue how helpful this is :)
--
MO
Albany, NY


"Rick Rothstein (MVP - VB)" wrote:

Does this formula do what you want?

=SUMPRODUCT(--ISNUMBER((SEARCH("NETSMART",'07-08 Pd. in
07-08-22820'!$A$4:$A$1000))),--('07-08 Pd. in
07-08-22820'!$E$4:$E$1000="53000.5300700001.00300.228200 .20070.56995.FMS"),'07-08
Pd. in 07-08-22820'!$B$4:$B$1000)

Rick


"MO" wrote in message
...
I need to create a formula where 2 column criteria must match--Columns A&E
(See Below)

Column A may only have partial information that matches (i.e. it
may show "Netsmart USA" one time and just "Netsmart"the next time--but it
will always show at least "Netsmart").

Column E will always be the same (i.e.,
"53000.5300700001.00300.228200.20070.56995.FMS ")
__________________________________________________ ______________
FORMULA
=SUMPRODUCT(--ISNUMBER(SEARCH("NETSMART",'07-08 Pd. in
07-08-22820'!$A$4:$A$1000('07-08 Pd. in
07-08-22820'!$E$4:$E$1000="53000.5300700001.0030.228200. 20070.56995.FMS")))--('07-08
Pd. in 07-08-22820'!$B$4:$B$1000))
__________________________________________________ _______________
If Columns A&E BOTH match, I want the total of Column B figures for the
match ONLY. Otherwise the result should be zero.

The result I keep receiveing is DOUBLE the amount of the ENTIRE Column B
not
just the matched criteria.
HELP!!



--
Thank you for your help
MO
Albany, NY