How can I count from the same date, data coming in? (A current week progress)

Monica Barrera

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 each-week sum, but then is hard to make a Dashboard for 52 weeks each year.

Paul Newcome

@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.

Jenn Burk

Try this:

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

Monica Barrera

@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"

Monica Barrera

@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??

Paul Newcome

You would need something along the lines of

=SUMIFS([Number Of Support]:[Number Of Support], [Week Number]:[Week Number], @cell = 25)

Monica Barrera

@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 😁

Monica Barrera

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

Monica Barrera

somehow this make it work

Paul Newcome

@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.