excel formula - Sum with multiple criteria by an array in cell value -


i want sumif criteria, want use array criteria. have found following formula works

https://exceljet.net/formula/sumifs-with-multiple-criteria-and-or-logic

=sum(sumifs(sum_range,criteria_range,{"red","blue"})) 

however, rather having hard coding red or blue, have cell "red", "blue" in it? possible have formula working off cell reference, rather hard coded?

sum(sumifs(re!g:g,re!c:c,{con!b4})) 


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -