Data is arranged as per the table in the image below. Need to summarize data based on the individual criteria on a daily basis.
You can do this with simple
If you have a lot of criteria, you can use an array formula instead:
In A12, store the list of criteria, separated by comma, i.e.
=SUM(($B$2:$B$8=$B12)*(IFERROR(SEARCH(" "&C$2:C$8&","," "&$A12&","),0)0))
Enter this as an array formula, i.e. press Ctrl-Shift-Enter.
|show 1 more comment|