Join formula of two sheets

Marilen.Navarro103391

Hello -

Shown is one sheet but two sources separate data . Can I combine the two counts anyway they have the same Primary column. I don't want to make a summary count of the two because I can't get rid of this in reporting.

Can you assist me with the formula? Thanks.

Ramzi

Here's another option:

In your sheet, create a third section that adds the results of the first two. It would have the same rows, but the formula for each row would add the cells of section 1 + section 2.

Add a helper column called ShowInReport as a Check Box and check all the rows in the third section.

Create a report and tell it to show you only Section 3 (where the ShowInReport is true.

I hope that makes sense.

Marilen.Navarro103391

@Ramzi Helper is good. I got it. Thanks for your help

Ramzi

If I understand you correctly, you can just add the two formulas together to get the total.

Marilen.Navarro103391

@Ramzi

hello. yes I can add the two formula but when I make a Report, it will show these two tables. Is there a formula where I can combine the sum of two sheets?

Ramzi

You could potentially use the Group/Summarize features in the report. Will that work?

Marilen.Navarro103391

@Ramzi so it means I wouldn't be able to join a count of two sheets in table form?

Ramzi

Here's another option:

In your sheet, create a third section that adds the results of the first two. It would have the same rows, but the formula for each row would add the cells of section 1 + section 2.

Add a helper column called ShowInReport as a Check Box and check all the rows in the third section.

Create a report and tell it to show you only Section 3 (where the ShowInReport is true.

I hope that makes sense.

Marilen.Navarro103391

@Ramzi Helper is good. I got it. Thanks for your help

Marilen.Navarro103391

@Ramzi I have another question, if you can help me set up with weekly count, starting September. I only know monthly, I haven't done weekly. Can you give me an idea? Thanks