count if
 

Hi ,

What would be the easiest way to calculate the number of entries in in the
following scenario :

B1 : B25 contains dates ( although not all fields will contain data yet )
C1 : C25 contains contact type details i.e. E-mail , phone call ( again not
all will contain data )

I want to show the number of contacts made within the last 4 weeks but omit
one kind (left message).

I am sure there is a simple way but cannot work it out !!

Thanks in advance

Hi,
I would recommend using a Pivot table to summarize your data. You can group
your data by weeks, and it will tally up all of your contacts by type.

For help on using a pivot table see the following sites:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.contextures.com/xlPivot01.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.ozgrid.com/Excel/excel-pivot-tables.htm


"G" wrote:


Hi ,

What would be the easiest way to calculate the number of entries in in the
following scenario :

B1 : B25 contains dates ( although not all fields will contain data yet )
C1 : C25 contains contact type details i.e. E-mail , phone call ( again not
all will contain data )

I want to show the number of contacts made within the last 4 weeks but omit
one kind (left message).

I am sure there is a simple way but cannot work it out !!

Thanks in advance

=SUMPRODUCT(--($B$1:$B$25=E2),--($B$1:$B$25<=F2),--($C$1:$C$25<""),--($C$1:$C$25<"left
message"))

where E2 and F2 house date conditions with E2 weeks before F2.


G Wrote:
Hi ,

What would be the easiest way to calculate the number of entries in in
the
following scenario :

B1 : B25 contains dates ( although not all fields will contain data yet
)
C1 : C25 contains contact type details i.e. E-mail , phone call ( again
not
all will contain data )

I want to show the number of contacts made within the last 4 weeks but
omit
one kind (left message).

I am sure there is a simple way but cannot work it out !!

Thanks in advance


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274332

Aladin you are a genious !!

thank you

"Aladin Akyurek" wrote:


=SUMPRODUCT(--($B$1:$B$25=E2),--($B$1:$B$25<=F2),--($C$1:$C$25<""),--($C$1:$C$25<"left
message"))

where E2 and F2 house date conditions with E2 weeks before F2.


G Wrote:
Hi ,

What would be the easiest way to calculate the number of entries in in
the
following scenario :

B1 : B25 contains dates ( although not all fields will contain data yet
)
C1 : C25 contains contact type details i.e. E-mail , phone call ( again
not
all will contain data )

I want to show the number of contacts made within the last 4 weeks but
omit
one kind (left message).

I am sure there is a simple way but cannot work it out !!

Thanks in advance


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274332