Beginner help: Add by cost centers

[JoaoVr]

Hey Everyone,
I`m kinda beginner at Excel and I was looking from some guidance. I have a Excel sheet at my work that we put all the costs by cost centers like this:
Sem_nome.png

For now I would like to add the values with the same Cost Center of the same month (Add all my cost Center #1 Structure costs from January)

Sorry for this terrible way of expressing myself

[shukla.ankur281190]

Assuming you have Cost Centre in A column Dates are in B column and Values are in C column, drop-down for month in F2 cell and cost drop-down in E2 cell then

F2

Please Login or Register  to view this content.

is result.



Check the attached file.

[JoaoVr]

Assuming you have Cost Centre in A column Dates are in B column and Values are in C column, drop-down for month in F2 cell and cost drop-down in E2 cell then

F2

Please Login or Register  to view this content.

is result.



Check the attached file.

I`m having some difficulties to link this formula to another sheet (Same file, different sheets) can you give me a example? Can the sheet name have spaces?

Thank you for your help

[shukla.ankur281190]

There should be no issue in sheet name, when you select ranges in excel itself understood sheet name and yes sheet name can have spaces.


If you are in trouble please attached your workbook with criteria explanation.

[FDibbins]

Use SUMIFS instead...
=sumifs(F:F,C:C,1,A:A,">="&start-date, A:A,"<="&eomonth(start-date))
where, based on your sample pic, your data starts in column A, and start-date is a cell containing the month you want, in the format mm/dd/yy or dd/mm/yy

[JoaoVr]

If I want to make this SUMIF in different sheet that the one I have the data, how can I make it?

Thanks in advance

[FDibbins]

The exact same way as if the calc was on the same sheet. Just start on the other sheet, and use the mouse to reference the range on the other sheet

[FDibbins]

Thanks for the feedback

[JoaoVr]

So far I managed to understand how SumIf work, I got this formula and its workig.

Please Login or Register  to view this content.

Now, if I want to separate my values per month, how can I do it?

My Data is like this:
image.png

How can I divide them by months?
image.png

Thanks for the feedback

There should be no issue in sheet name, when you select ranges in excel itself understood sheet name and yes sheet name can have spaces.


If you are in trouble please attached your workbook with criteria explanation.