Thread: Sum Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jamecs jamecs is offline
external usenet poster
 
Posts: 1
Default 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.