I need someone to create a formula for calculating something in Google Sheets

Status
Not open for further replies.

Myst3ry

Elite Member
Joined
Jul 6, 2013
Messages
1,533
Reaction score
1,400
I have 4 tabs. All of them have data, and I want to have the sum of specific rows and separating them by separate months. The date is written as 11.01.2022

So, if the rows has the name George, count the value in x cell and all that separated by months in new tab.

$5-10

Thanks!
 
Just add another "helper" sheet and order the numbers by months using sumif and month functions.
Then design another sheet in the way you want your report to look like and sum them up. If you'll use the iferror fx with the sum function, the empty months will show 0 instead of an error.

And as I write this comment I think you can even use just use sumif and month in your report sheet.
 
Status
Not open for further replies.
This thread has been auto closed due to the forum's thread age policy. Read more.
Back
Top