Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there I'm having trouble getting the formula I need.
in an Excel sheet with data, I have a column that is calls 'week number', one is called 'Year' and I have a column called 'Incident Number'
I want to count all the Incident numbers in the current week and the current year.
First I used this formula Count(IF([Week number]= Week(Today()),[Incident Number])) which works but now I need to add the Year as well.
any one who call help me?
May be this
Count({<[Week number] = {"$(=Week(Today())"}, Year = {"$(=Year(Today())"}>} [Incident Number])
Try;
=Count(IF([Week number]= Week(Today()) and Year= Year(Today()),[Incident Number]))
Example Attached
Thanx! that works, I had tried some thing that looks like it but could nog get it to work..Hmm must be my lack of skills...
What worked? My response or gareth_wilson124's response?
Please close the thread by marking correct and helpful responses.
Best,
Sunny