Last seen: Jun 25, 2026
Best if you can upload a file with an example of your data and the result that is expected. Otherwise look into using the SUMIFS function as that's th...
@chosen67 Your issue has nothing to do with the fragmentation and duplication phenomena described in the video. Change the rule to: =COUNTIFS($C$...
@chosen67 Please try uploading your file again. It didn't come through. Otherwise, save it to OneDrive or similar and share the link that gives ful...
@abdallahh Most likely due to the fact that your dates are in the wrong format. Which locale does your setup expect? dd/mm/yyyy or mm/dd/yyyy I ...
Aha! Then please explain all the logic to be applied. Edit: Perhaps the attached file does what you need.
@lanser Difficult to visualise exactly what you are dealing with, but my gut feeling says that you could unpivot the data first and then use the “At...
@j8150outlook-com Thanks. Would actually like to see the query of the 'invoked function'. Does it include some filtering step that may exclude the l...
@jessica5 Not sure I fully comprehend your logic here, but note that 0.44 equals 44%. You probably want to use 0.0044 (=0.44%) in your format. And I...
@j8150outlook-com Difficult to say without seeing (at least) the query and a screenshot of the folder with the 25 files in it. Make sure that the fi...
@mwahaab Sorry for being slow in understanding. In the attached file I added/changed som columns/formulas (C, D and E) that result in the Variance ...
@mwahaab In your example, the total budget is higher than the Annual Cost. So it could be relatively easy to allocate the minimum of Cost and Budget...
@benjamip You don't show the context in which you apply the formula. Though, two matters come to mind: 1) You index a range from row 5 to 53, but ...
@jessica5 Sorry! I was confused. I now could download the file without logging in. See attached. I first manually correct the order of Subj...
@jessica5 I could not get into you file without asking permissions. You should be able to upload it with your message to the forum also. Anyhow, thi...
@senlo I would really need to see your file but don't understand why you can't upload a file. A regular xlsx workbook should work. I'm attaching one...