How can I count from the same date, data coming in? (A current week progress)
I'm creating KPI document, where the team enter the weekly update and wants to count the number of support given in one week.
I just want to say if "Week Number" = Same! then Sum "Number of Support"
But I can not get the "SAME" in the IF of SumIF because for not it the symbols are <>, but for being the same?? = =?
I'm thinking of making on Summary Sheet, a eachweek sum, but then is hard to make a Dashboard for 52 weeks each year.
Best Answer

@Monica Barrera Yes. You would need to use
WEEKNUMBER(@cell) = WEEKNUMBER(TODAY())
as the criteria to get it to compare to today's week number.
Answers

Try this:
=IF(WEEKNUMBER([Support Week]@row) <> [Week Number]@row, "True", "False")

@Jenn Burk Thanks! because is a good start, but my problem is that Support week and Week number are the same
The Week Number is actually a =WEEKNUMBER([Suport Week]@row
So I get only False.
But is a good start so Im failing on the =IF[WEEKNUMBER(TODAY()) <>[Week Number]@row, "True", "False"

@Paul Newcome I saw you help someone on something similar, but I have no idea how to apply it for mine. :) can you help me??

You would need something along the lines of
=SUMIFS([Number Of Support]:[Number Of Support], [Week Number]:[Week Number], @cell = 25)

@Paul Newcome yeah, but how do I do it to change the sum depending on the current week ? do I have to do 52 fields in the Summary Sheet?
I want to read the count of the WEEKNUMBER.
I want to be able to Sum up all the support for the current week from different people 😁

How do I make it say for week 25 (current week) Roberto Ramos had 4 supports
Next week would be week 6 and Roberto Ramos might have 10 supports or 2 , I want a formula that knows what data is happening in the current week

somehow this make it work

@Monica Barrera Yes. You would need to use
WEEKNUMBER(@cell) = WEEKNUMBER(TODAY())
as the criteria to get it to compare to today's week number.
Help Article Resources
Categories
Check out the Formula Handbook template!