Mar 27 2023 01:57 PM
Mar 27 2023 02:08 PM
Mar 28 2023 06:49 AM
@Hans Vogelaar . Its the way the calculation needs to be done .... Depending on the Column "C"... if you look at Column C, there are numbers /codes, For each code I need to know the total in the the row situated in column I , but sometimes there these codes appear more than once (2 times mostly), so I cant total duplicates, I need to subtract the duplicate looking at column E if there is a variable named 09: 500+ Employees & then get the total in Column I in the same row
Does this make sense to you??
Mar 28 2023 07:08 AM
No, I don't understand why you subtract a value from column G in one case and from column F in another.
Mar 28 2023 07:24 AM - edited Mar 28 2023 07:25 AM
@Hans Vogelaar Actually that was my mistake.(thanks for pointing it out). G column data is irrelevant. I changed the calculation to F2-F3 now... I think now you will understand if you see the sheet. The Totals are always calculate using numbers in F column if you see my examples..... any idea how I could calculate it for the entire sheet of 100k rows?
Mar 28 2023 07:55 AM
In I2:
=IF(RIGHT(E2, 5)="Total", F2-SUMIFS($F$2:$F$100000, $C$2:$C$100000, C2, $E$2:$E$100000, "<>*Total"), "")
Fill down.
Mar 28 2023 09:28 AM
Mar 28 2023 12:26 PM
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?