Recent content by gina clemens

Hi, Thanks I have tried that but it doesn't give me the answer I am after. The sumifs formula works how I would like the countifs function to but gives me the sum not the count obviously - but it is the sum of the results in column H. But the countifs function just looks at criteria range...

Hi, I have a large set of data I am working on which contains alot of moisture data. Within my huge set of data there are moisture readings that come from various treatments. I am trying to do averages on a bunch of these different treatments for which I am using an averageifs statment which...

https://www.dropbox.com/s/aw13w4rz4hxunj7/air%20temperature.xlsx hope that works :)

ok call me a novice.... how do I upload a file on here?

Hi Narayan, Sorry about the delayed response, I had to approach my problem differently as I couldn't get the formula to work and it skipped my mind but I have just encountered the same problem in another file. I will upload the new file I am having the issue with as it is far smaller and...

Thanks Narayan. I have just had a go at what you suggested and get a value to 10 decimal places but it is still excally the same number for both the cell it is looking up and the one it should be finding. Thanks though - any other suggestions?

Thanks Sorry for my slight confusion but do you mean copy the formula and paste as a value? I tryed copying the formula in H128 and pasting as a value, no luck, so also did the same with the cell that it should be looking up in the array and still no luck. But if i select the cell it should be...

Hi, I am using the formula =VLOOKUP(H128,'First Conversion'!$1:$1048576,MATCH(G126,'First Conversion'!$1:$1,0),FALSE) The cell H128 that I am looking up is a date and time which has been created using a formula. When I use the vlookup above it works fine for the first two dates and times...