Sumifs

[hanif]

Hi All,

I have a Database showing propoerty name (which each has multiple enteries), Dates, Fuel type (diesel or petrol), and costs. I have them in a table called table1. I have another table which I want to sum the values based upon different criteria.

I have used the following formula to sum the values of each property and a specific fuel type.

=SUMIFS(Table1[CO2 Emission (tonnes/a)],Table1[Property Code],[@[Property Code]],Table1[Fuel Type],[@[Fuel Type]])

this gives me the value for the entire year. what should I add to the above formula to sum the values only for Jan,Fen and mar?

Thanks,

[MarvinP]

Hi hanif,

Instead of using SumIFS for a formula, I'd do a Pivot Table. If you make your Dates the first Row item in the pivot, you can group by months, you could also make the fuel type a column and the emission the value. If you attach a sample workbook, we can show you how to Pivot your data to get what I think you want, without a formula.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[hanif]

Thanks Marvin, I was actually trying to get something else but the idea of Pivot Table helped.

[xlnitwit]

Hi,

For SUMIFS you could use something like this
=SUMIFS(Table1[CO2 Emission (tonnes/a)],Table1[Property Code],[@[Property Code]],Table1[Fuel Type],[@[Fuel Type]],Table1[Date],">="&date(2017,1,1),Table1[Date],"<"&date(2017,4,1))

[hanif]

thank you this is exactly what I was looking at.

Hi,

For SUMIFS you could use something like this
=SUMIFS(Table1[CO2 Emission (tonnes/a)],Table1[Property Code],[@[Property Code]],Table1[Fuel Type],[@[Fuel Type]],Table1[Date],">="&date(2017,1,1),Table1[Date],"<"&date(2017,4,1))