How to create a weekly/monthly report

Andrée Starå

@Beronica Muller

Apologies! Been away, one of my daughters graded up in Taekwondo today.

I see that Paul is helping you. Did you get it working?

Beronica Muller

@Andrée Starå No worries, I figured that you were busy.  I tried Paul's suggestion but I am still receiving an error message.  Could you please take a look at the sheet and let me know what I am doing wrong?

Paul Newcome

What steps did you take to create the cross sheet reference? Is the formula showing in your screenshot fully? For some reason I am unable to open it.

I notice that the opening parenthesis after COUNTIFS is not color coded to match anything else and the opening parenthesis before the first IFERROR is matched up with the final closing parenthesis. It looks like you are using an AND function but don't actually have the AND in there...

=COUNTIFS({Range 1}, {Range 2}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2020))

Paul Newcome

I took another look through the thread. It looks like there were a few things that got dropped off as the formulas got tweaked. Here are two formulas for you. One to sum a range and another to count the dates.

=SUMIFS({Range 1}, {Range 2}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2020))

=COUNTIFS({Range 2}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2020))

Sorry for getting it mixed up...

EDIT: I am going to recommend the COUNTIFS. Based on one of your previous screenshots using the SUMIFS, you are referencing the timestamp column as the range to SUM. I assume you are wanting to count instances and not necessarily add up a bunch of other numbers based off of the date.

If in fact you ARE adding up other numbers based on the dates, then you will want to use the SUMIFS instead.

Beronica Muller

YAY!!!  I think that I have what I needed.

Thanks @Paul Newcome and @Andrée Starå!!! You guys are the BEST!!!

Andrée Starå

@Beronica Muller

Excellent!

Thanks!

Gad that you got it working!

Happy to help!

Have a fantastic weekend!

Paul Newcome

Happy to help! 👍️