List month from any given year in excel
Solved/Closed
Related:
- List month from any given year in excel
- Counter strike 1.6 cheats list - Guide
- All contact number list with name - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
- How to change your best friends list on snapchat to 3 - Guide
5 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Jun 4, 2009 at 02:59 AM
Jun 4, 2009 at 02:59 AM
you can get the file from here ....... feel free to ask , in case of any query
http://d01.megashares.com/dl/c16deb5/approved-rejected.xls
PS actually many sites have been blocked by our organization so you or anyone else know some nice site to upload file please do let me know .... I've tried almost 50 sites and only this was not blocked .......
http://d01.megashares.com/dl/c16deb5/approved-rejected.xls
PS actually many sites have been blocked by our organization so you or anyone else know some nice site to upload file please do let me know .... I've tried almost 50 sites and only this was not blocked .......
thanks alot dude...m trying to work it out...but getting 0 as count. whereas it shud be 9
=SUMPRODUCT(--(YEAR('Claim Report'!O1:O25000)=YEAR($C$14))*--(MONTH('Claim Report'!O1:O25000)=A16),--('Claim Report'!R1:R25000=$D$15))
u can try www.sendthisfile.com for free upload
=SUMPRODUCT(--(YEAR('Claim Report'!O1:O25000)=YEAR($C$14))*--(MONTH('Claim Report'!O1:O25000)=A16),--('Claim Report'!R1:R25000=$D$15))
u can try www.sendthisfile.com for free upload
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Jun 4, 2009 at 05:36 AM
Jun 4, 2009 at 05:36 AM
=SUMPRODUCT(--(YEAR('Claim Report'!O1:O25000)=YEAR($C$14))*--(MONTH('Claim Report'!O1:O25000)=A16),--('Claim Report'!R1:R25000=$D$15))
Check your Cell Reference YEAR($C$14) & $D$15 ..... Or check that you are entering date in proper format ....
below site is also blocked as i'm getting below info ....
Default Web Filtering Policy Blocked site category:File Host,Internet Services
I think if some sites don't have these parameters then i can share it ..... or i can share my files on some valuable forums .....
anyway check your formula again and do let me know ....
Check your Cell Reference YEAR($C$14) & $D$15 ..... Or check that you are entering date in proper format ....
below site is also blocked as i'm getting below info ....
Default Web Filtering Policy Blocked site category:File Host,Internet Services
I think if some sites don't have these parameters then i can share it ..... or i can share my files on some valuable forums .....
anyway check your formula again and do let me know ....
Didn't find the answer you are looking for?
Ask a question
Jul 13, 2009 at 11:25 PM