| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Count the text in a column - Part II | Excel Discussion (Misc queries) | |||
| filter and count | Excel Discussion (Misc queries) | |||
| How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Hybrid Mode
