Hi,

I am creating a Sumproduct fromular with many different conditions,

I have noticed that you can put "+" "--," or "," or even, ",+" between the conditions or arrays.

I am getting a bit confused as to which one to use, my formular is error free and returning 0 or gives a value if i change a few about.

Basically i am trying to get the sum, where the time of any events are on a weekday and between 18:00pm and 04:00am

My formular therefore needs to say in simple terms.... if monday or tuesday or wednesday or thursday or friday then add up the data where it occurs between 18:00 and 04:00

What seperators should i use between the arrays to achieve this?

Many thanks in advance