Data shud be counted under f and g any number of times it appears but if same data is found under b,c,d,e , it should be ignored. Pls help!

[fathima]

A	B	C	D	E	F	G
	TOTAL TICKETS
Date	WEB	SWOT	CTS	BACKLOG	CHATS	CALLS
5-Feb	inc12
5-Feb		inc12
5-Feb	inc12				inc12
6-Feb						inc12
6-Feb			INC12
7 feb					ritm12	ritm12

7-Feb

ritm12

Very critical as need to submit by tomorrow .. please assis on this, I will be ever grateful

Here , columns (b,c,d,e) are one group
columns (f and g ) are another group (both needs to be compared)
Columns A contains date

Here, RITM12 and INC12 (short for 'incident') are ticket numbers.
There are different ways that these tickets are logged.
So when the ticket is logged via a call or chat, i want to count each individual time it appears for a specific date.(f and g)
But if that ticket number is logged by web, swot, cts or backlog it should only count it once.(b,c,d,e)
If same ticket ex ritm12 is entered under chats(f and g group) , it will count as 1 ignoring same value which is also entered in (b,c,d,e) under web for 7 feb + ritm12(under call) so value should be 2


here 5th feb ( value should be 1) , 6th feb ( value should be 1) , 7th feb ( value should be 2, because it contains under call and chat)
so total - 1+1+(1+1)=4(i need this value in single cell)