Sum of more than two colume using conditions

[stephenb465]

excel.png
I there

I have a couple of questions which has been doing my head in for a while

I have a spreed sheet that I use to manage my couple of properties I own,
in the spread sheet, I keep records of the expense and income of each of the properties.
One column I have the year (financial year)
Another column I have a pull down menu for type of activity, such as, income, renovation, purchase cost, interest paid, maintenance management fees
Another column the amount
Another column which property it come from
There are a couple of things I would like to do, however, my first issue it
On the presenation page, I want to know the cost of purchasing the property
Such as
Property A
So I’m guessing the formula needs to go down the column and find all the entries relevant to Property a
Then go into the next column the has “purchasing costs”
Then give me a sum.

Thanks for your assistance


Stephen

[:) Sixthsense :)]

Hi stephenb465,

Welcome to the forum

Please attach a sample workbook with expected output for better understanding.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[stephenb465]

see below the forula, this is what I want to understand, this was taken from C14
but when I do edit the { it creats a problem and the formula no longer works

{=ROUND(SUM(($B$2=details!$A$2:$A$1763)*(C$5=details!$E$2:$E$1763)*($A14=details!$F$2:$F$1763)*(details!$G$2:$G$1763)),0)}

I wanted to look at another way to calulate my spread sheet

also, I wanted to have another colume that just adds up the cost of purchasing the Properties without defining the year, I was thinking about putting the below the report form