Hi there,
I'm having problems with the if-function in Excel 2003.
This is the case:
I have a sheet with dates on which assignments were executed.
Now I want to count them by week.
from 1-1-2012 untill 1-7-2012 -> 32 assigments were executed (so 32 different dates in column within the range 1-1-2012 / 7-2012)
from 1-1-2012 untill 1-7-2012 -> 28 assigments were executed (so 28 different dates in column within the range 8-1-2012 /14-2012)
etc.
Does anyone have a clue?
thnx
Val.
You mean?
=COUNTIF(A:A,">="&DATE(2012,1,1))-COUNTIF(A:A,">"&DATE(2012,1,7))
Where column A is your column of interest.
Note: You may have to replace commas with semi-colons for your version:
=COUNTIF(A:A;">="&DATE(2012;1;1))-COUNTIF(A:A;">"&DATE(2012;1;7))
You can also use a Pivot Table and group by Week...
http://www.contextures.com/xlPivot07.html#Week
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Yes mate! That's it... now I see it it makes sense to me. But honestly, I couldn't have come up with this myself :-)Originally Posted by NBVC
THNX !
One final addition...
There are 2 suppliers and I want to filter them. In Column B you'll have supplier A or supplier B.
Tried =(COUNTIF(A:A;">="&DATE(2012;1;1))-COUNTIF(A:A;">"&DATE(2012;1;7)))&(B:B="supplierA")
Not working :-(
Last edited by van_vugt; 06-29-2012 at 10:08 AM.
Try, for 2003 ...
With 2007 and above you can use COUNTIFS()
Please Login or Register to view this content.
Last edited by Marcol; 06-29-2012 at 10:06 AM. Reason: Changed comma separator to semi-colon
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
sorry... didn't see your edit earlier....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks