Simplifying logging of the merits of a day in a monthly calender

K

Kreller

I'm making an activity log where I in one sheet have a list of contac
companies and persons. I'm using it in canvas sales and want to lo
date and time for each call I make. For each company I have made roo
for 4 persons and three rounds of contact for each. That gives 1
columns of interest.

when I have contacted a person, I use a list with "meeting"
"call-back", "not-qualified" and so on. In sheet 2 I have set up
calender for the month and where I want to log how many contacts I hav
made each day and how many meetings have been arranged. I use th
SUMPRODUCT for this and it works, but it is very tedious as I have t
check 12 cols for each date

The formula is

=SUMPRODUCT(--(Emnebase!N$3:N$998<>"Ikke komme
igennem");--(Emnebase!BX$3:BX$998=A22))+SUMPRODUCT(--(Emnebase!R$3:R$998<>"Ikk
komme
igennem");--(Emnebase!BY$3:BY$998=A22))+SUMPRODUCT(--(Emnebase!V$3:V$998<>"Ikk
komme
igennem");--(Emnebase!BZ$3:BZ$998=A22))+SUMPRODUCT(--(Emnebase!AE$3:AE$998<>"Ikk
komme
igennem");--(Emnebase!CD$3:CD$998=A22))+SUMPRODUCT(--(Emnebase!AI$3:AI$998<>"Ikk
komme
igennem");--(Emnebase!CE$3:CE$998=A22))+SUMPRODUCT(--(Emnebase!AM$3:AM$998<>"Ikk
komme
igennem");--(Emnebase!CF$3:CF$998=A22))+SUMPRODUCT(--(Emnebase!AV$3:AV$998<>"Ikk
komme
igennem");--(Emnebase!CJ$3:CJ$998=A22))+SUMPRODUCT(--(Emnebase!AZ$3:AZ$998<>"Ikk
komme
igennem");--(Emnebase!CK$3:CK$998=A22))+SUMPRODUCT(--(Emnebase!BD$3:BD$998<>"Ikk
komme
igennem");--(Emnebase!CL$3:CL$998=A22))+SUMPRODUCT(--(Emnebase!BM$3:BM$998<>"Ikk
komme
igennem");--(Emnebase!CP$3:CP$998=A22))+SUMPRODUCT(--(Emnebase!BQ$3:BQ$998<>"Ikk
kommet igennem");--(Emnebase!CQ$3:CQ$998=A22))



It works, but as you can see it is quite long and tedious and it work
rather slowly. Do you have a suggestion as to how to simplify it
 
Top