Please help.
My workbook has 2 sheets - Sheet 1 (data) & Sheet 2 (report)
I am trying to calculate the cost of repairs to a number of properties. So Sheet 1 Column D contains the address of the property, Column H contains the cost (some positive and some negative amounts). A5 refers to Sheet 2 (address of property).
In Sheet 2 I have the following formula which is currently working: = SUMIF('Sheet 1'!D:D, A5,'Sheet 1'!H:H)
My problem is that I do not want it to include negative amounts when adding the numbers
I tried the following formula which is returning "Too many arguments" error message: = SUMIF('Sheet 1'!D:D, A5,'Sheet 1'!H:H,">0")
Any assistance would be appreciated.
My workbook has 2 sheets - Sheet 1 (data) & Sheet 2 (report)
I am trying to calculate the cost of repairs to a number of properties. So Sheet 1 Column D contains the address of the property, Column H contains the cost (some positive and some negative amounts). A5 refers to Sheet 2 (address of property).
In Sheet 2 I have the following formula which is currently working: = SUMIF('Sheet 1'!D:D, A5,'Sheet 1'!H:H)
My problem is that I do not want it to include negative amounts when adding the numbers
I tried the following formula which is returning "Too many arguments" error message: = SUMIF('Sheet 1'!D:D, A5,'Sheet 1'!H:H,">0")
Any assistance would be appreciated.