SUM IF AND

[Guest]

Please see formula below:

I'm trying to have the formula add currency (column B) but it must meet two
criteria (column A[may not always have the whole name] & column E).
Everything I've tried doesn't work. Can you assist?

=SUMIF(AND('07-08 Pd. in
07-08-22820'!"53000.5300700001.00300.228200.20070.56995.FMS",'07-08 Pd. in
07-08-22820'!"NETSMART NEW YORK INC")(A4:A1000)(E4:E1000),'07-08 Pd. in
07-08-22820'!B4:B1000,'07-08 Pd. in 07-08-22820'!)

 

[Guest]

I couldn't make much out of your example, but
Possibly something like this:

=sumproduct(--isnumber(Search("some
value",$A$4:$A$1000)),--($E$4:$E$1000="ABC"),$B$4:$B$1000)


Use the same set up I used for A for E if you are looking for a substring
there as well.

 

[Guest]

Excellent and thank you.
--
Thank you for your help
MO
Albany, NY

I couldn't make much out of your example, but
Possibly something like this:

=sumproduct(--isnumber(Search("some
value",$A$4:$A$1000)),--($E$4:$E$1000="ABC"),$B$4:$B$1000)


Use the same set up I used for A for E if you are looking for a substring
there as well.
--
Regards,
Tom Ogilvy

Please see formula below:

I'm trying to have the formula add currency (column B) but it must meet two
criteria (column A[may not always have the whole name] & column E).
Everything I've tried doesn't work. Can you assist?

=SUMIF(AND('07-08 Pd. in
07-08-22820'!"53000.5300700001.00300.228200.20070.56995.FMS",'07-08 Pd. in
07-08-22820'!"NETSMART NEW YORK INC")(A4:A1000)(E4:E1000),'07-08 Pd. in
07-08-22820'!B4:B1000,'07-08 Pd. in 07-08-22820'!)

 

[Guest]

Sorry, I thought it was going to work.

2 colums criteria must match--Columns A&E.

Column A may only have partial inforamtion that matches, therefore (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"

If they BOTH match, I want to total Column B. Otherwise the result should
be zero.
--
Thank you for your help
MO
Albany, NY

I couldn't make much out of your example, but
Possibly something like this:

=sumproduct(--isnumber(Search("some
value",$A$4:$A$1000)),--($E$4:$E$1000="ABC"),$B$4:$B$1000)


Use the same set up I used for A for E if you are looking for a substring
there as well.
--
Regards,
Tom Ogilvy

Please see formula below:

I'm trying to have the formula add currency (column B) but it must meet two
criteria (column A[may not always have the whole name] & column E).
Everything I've tried doesn't work. Can you assist?

=SUMIF(AND('07-08 Pd. in
07-08-22820'!"53000.5300700001.00300.228200.20070.56995.FMS",'07-08 Pd. in
07-08-22820'!"NETSMART NEW YORK INC")(A4:A1000)(E4:E1000),'07-08 Pd. in
07-08-22820'!B4:B1000,'07-08 Pd. in 07-08-22820'!)

 

[Guest]

Suggested a solution in response to your later post.

--
Regards,
Tom Ogilvy

Sorry, I thought it was going to work.

2 colums criteria must match--Columns A&E.

Column A may only have partial inforamtion that matches, therefore (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"

If they BOTH match, I want to total Column B. Otherwise the result should
be zero.
--
Thank you for your help
MO
Albany, NY

I couldn't make much out of your example, but
Possibly something like this:

=sumproduct(--isnumber(Search("some
value",$A$4:$A$1000)),--($E$4:$E$1000="ABC"),$B$4:$B$1000)


Use the same set up I used for A for E if you are looking for a substring
there as well.
--
Regards,
Tom Ogilvy

Please see formula below:

I'm trying to have the formula add currency (column B) but it must meet two
criteria (column A[may not always have the whole name] & column E).
Everything I've tried doesn't work. Can you assist?

=SUMIF(AND('07-08 Pd. in
07-08-22820'!"53000.5300700001.00300.228200.20070.56995.FMS",'07-08 Pd. in
07-08-22820'!"NETSMART NEW YORK INC")(A4:A1000)(E4:E1000),'07-08 Pd. in
07-08-22820'!B4:B1000,'07-08 Pd. in 07-08-22820'!)