Hi,
I am looking for a way to add up a list of array items that CONTAIN, not MATCH, a search query...
eg: I know how to search an array to find a match that holds '/home/' but this only matches an exact cell match.
"{=SUM((A21:A34=A1)*(B21:B34))}"
how would I amend the '(A21:A34=A1)' part so that the condition can expand to contain the target text '/home/' as ANY PART OF the search inquiry, not just return the exact matches:
in the example below:
"{=SUM((A21:A34=A1)*(B21:B34))}" = "3000" - ie 3x exact matches
"{=SUM((A21:A34='anything that contains '/home/')*(B21:B34))}" = 11 matches, ie total 3352
SAMPLE DATA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ROw 1-2
/home/ 3000 {=SUM((A21:A34=A1)*(B21:B34))}
home home =MID(A21,(FIND(A3,A21,1)),LEN(A3))
...
ROW 21+
COLUMN A COLUMN B
SAMPLE DATA pageviews
/home/ 1000
/home/player/ 55
/home/player/teamid 33
/home/ 1000
/home/player/ 55
/home/player/teamid 33
/home/player/ 55
/home/player/teamid 33
/home/ 1000
/home/player/ 55
/home/player/teamid 33
destination 777
team 333
team/england 3333
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
THANKS for any help you can provide
DAVE
Bookmarks