COUNT VALUES DEPENDING ON DATES
Closed
VE
-
Aug 19, 2009 at 12:47 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 21, 2009 at 06:44 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 21, 2009 at 06:44 AM
Related:
- COUNT VALUES DEPENDING ON DATES
- Different dates of "end to end encryption message" on blank chat? - Google Chrome Forum
- How to count names in excel - Guide
- Based on the values in cells b77 b81 c77 - Excel Forum
- Count sentences ✓ - Programming Forum
- Based on the values in cells b77 ✓ - Excel Forum
3 responses
Hi,
Thank you so much, it works!!!
One question though, I should press Ctrl-Shift-Enter rather than Ctrl-Alt-Del at the end?
The '*' between arguments stands for logical 'AND'? MS Help is a bit obscure at times. I couldn't find that anywhere.
Thanks again.
VE
Thank you so much, it works!!!
One question though, I should press Ctrl-Shift-Enter rather than Ctrl-Alt-Del at the end?
The '*' between arguments stands for logical 'AND'? MS Help is a bit obscure at times. I couldn't find that anywhere.
Thanks again.
VE
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Aug 20, 2009 at 11:52 AM
Aug 20, 2009 at 11:52 AM
Use the formula =SUM(($B$1:$B$8<=$A$12)*($B$1:$B$8>=$A$11)*($A$1:$A$8=2))+SUM(($B$1:$B$8<=$A$12)*($B$1:$B$8>=$A$11)*($A$1:$A$8=1)) Press CTRL + ALT+DEL
to enter the formula
$A$12 - end date
$A$11 - start date
to enter the formula
$A$12 - end date
$A$11 - start date
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Aug 21, 2009 at 06:44 AM
Aug 21, 2009 at 06:44 AM
pressing Ctrl+Alt+Del is set to bring up the Windows Security dialog in windows OS
The '*' between arguments stands for multiplication
The '*' between arguments stands for multiplication