Tickets calculation

[fathima]

A small question,

SL NO	Date	WEB ticket	sum
1​	1-May​	inc7	1 (since 1 web is mentioned for 1 date ie MAY 1st)
2​	1-May​	inc7	0 (since same ticket worked on one same date)- May 1st
3​	1-May​	inc3	1 (since different ticket worked on same day) May 2nd
4​	2-May​	inc7	1 ( Should add since same ticket worked on different day) May 2nd
		total	3

I Just need value for total mentioned in last row ie (sum of all tickets based on logic mentioned separately in each row).

The value should be 3 (Need formula for this)

Thankyou in advance

 

[Peter_SSs]

Duplicate to Calulating tickets for each date.

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.