Sum Array
 

I'm trying to sum based on multiple criteria. One of the criteria is if the
text in a cell includes a specific word.

ex) {=Sum(($b$4:$b$1900=v$62)*($e$4:$e$1900="*Maples") *$d$4:$D$1900)}

The Maples would be the word within the text in a cell. I noticed that using
the * works in a Sumif formula but can't figure out how to use it in a
formula that needs multiple criteria.

Sum Array
 

One way (not an array formula):

=Sumproduct(--($b$4:$b$1900=v$62),
--(right($e$4:$e$1900,6)="Maples"),
($d$4:$D$1900))



jamecs wrote:

I'm trying to sum based on multiple criteria. One of the criteria is if the
text in a cell includes a specific word.

ex) {=Sum(($b$4:$b$1900=v$62)*($e$4:$e$1900="*Maples") *$d$4:$D$1900)}

The Maples would be the word within the text in a cell. I noticed that using
the * works in a Sumif formula but can't figure out how to use it in a
formula that needs multiple criteria.

--

Dave Peterson

Sum Array
 

Is the * before Maples a wildcard?

If so: (normally entered, not an array)

=SUMPRODUCT(--(B4:B1900=V62),--(ISNUMBER(SEARCH("Maples",E4:E1900))),D4:D1900)

Biff

"jamecs" wrote in message
...
I'm trying to sum based on multiple criteria. One of the criteria is if
the
text in a cell includes a specific word.

ex) {=Sum(($b$4:$b$1900=v$62)*($e$4:$e$1900="*Maples") *$d$4:$D$1900)}

The Maples would be the word within the text in a cell. I noticed that
using
the * works in a Sumif formula but can't figure out how to use it in a
formula that needs multiple criteria.