Hello all.
I am trying to run a sumif formula between Cells C6:E1000 and E6:E1000 to calculate the total if in cells B6:B1000 is equal to certain text. But also subtract cells D6:D1000 if B6:B1000 is equal the same text as before.
For example column total amount between C (1000) + E (25) if B = "um" then subtract D (200) if also B equal "um"
B6: "um"
C6: 1000
E6: 25
Subtracting D: 200
Hope that makes sense.
Many thanks for your help and guidance.
I am trying to run a sumif formula between Cells C6:E1000 and E6:E1000 to calculate the total if in cells B6:B1000 is equal to certain text. But also subtract cells D6:D1000 if B6:B1000 is equal the same text as before.
For example column total amount between C (1000) + E (25) if B = "um" then subtract D (200) if also B equal "um"
B6: "um"
C6: 1000
E6: 25
Subtracting D: 200
Hope that makes sense.
Many thanks for your help and guidance.