giving

My formula is =SUMIF(B6:B93,A101,L6:L93) the condition im looking for is if B6:B93 =B101 then add the numbers from L6:L93 together but when i do its giving me 0 instead of 1 i surely cant be too far wrong TIA

I have a number of queries in a workbook that are giving an error of 'download did not complete' It is not giving me any more info or any clues on how to fix the error. I have multiple sheets pulling from the same tables, and this is the only one with the error, so I'm not sure where to start...

I am currently using several stages to achieve my goal andwonder whether there is a more efficient way to do this, hopefully just in onecell. I have a cell which contains letters and numbers which canbe between 6 and 12 characters long and for cells which contain more than 6, Iwish to be able...

All, I am trying to set up a spreadsheet where each tab "belongs" to a individual, and would like to set up a "button" they can click that will grab a "signature image" from their files and insert in that spot. I have gone thru the post and was able to find the below code but it is giving me a...

I am trying to find % contribution. I know the answer to %18.29/$43.36 should equal 0.42181 which would be 42.18% but excel is giving me the answer 42.1877 rounding it to 42.19%. My answer needs to be 42.18%. How do I fix this?

Good Day Experts~ Really need a favor and help from all of you. I am trying to do the following graph, but my table is not giving the desired graph. Can I seek your expert advice on how my table format should be to achieve the end results. Thank you very much~ Appreciate it...

Hi, this is a fairly newbie question, and my first post on here, so bare with me here! I'm currently taking a course on Excel for beginners, and I'm currently stumped on a problem. My assignment has us calculating insurance/doctor's visits with a copayment of $25.00 and this specific problem...

I have a column with 59 entries that are times and I need to sum the total I have the column formatted in h:mm:ss but it keeps giving me 0:00:00 for the total I'm trying to total up A1:A59

hi trying to find a formula for my leave tracker which has a calendar and is as follows: C11:AG11 = Days in the months by the number format B12:B23 = months in the year: Example: "january" C12:AG23 = infractions or paid time off we enter but i want the formula to look for "EG/IG" and if so...

Hi, everyone...I'm here with another hopefully easy question! Management has given me a pre-existing report and wants me to improve it. One of the improvements they are asking for is with a yearly formula that takes a number from a month last year and compares it to a number from the same...

Hi everyone, I have a bit of a complex problem. I have a column like the following; Training: 7, Fighting: 12, Speed: 3 I need a formula that sums together 7+12+3 automatically. Now I got a solution where i extract all the digits in that cell and sum. But that ends up giving me 7+1+2+3...

I fail to understand why the below formulas give different results. When I do the calculation manually, the SUMPRODUCT seems to be giving the correct result. =SUMIFS(J1:J1000,K1:K1000,"<>Pending") Result is 43505 =SUMPRODUCT(--(K1:K1000<>"Pending"),J1:J1000) Result is 53595

Dear All, I'm using excel 2013 @ my workplace, and colleague asked me a question regarding VLOOKUP approximate match. Now the way I learned it from Mike Girvin is that it looks through the list and finds the 1st value that is larger, jumps back 1 row and delivers wichever col_index_no you've...

Hi All, I am using a macro for last one and half year for creating a report to be sent to the user, but suddenly from yesterday, it started giving me error " File Not Found 'C:Users\31946450\AppData\Local\Temp\VBCE74.tmp . I had not changed anything in the configuration of the system or excel...

In column C i have weekly totals in Column E i sum every 4 weeks to give me a monthly totals. Problem im having is getting Column E to be blank when Column C has 4 blanks. I'm currently using =SUM(C26:C29) but this is giving me a 0 in Column E which in turns is giving me a false reading on my...

Hello all, im new to access. Ive been hunting for a way to filter by the criteria of Between date-1 at 07:00 am and date at 07:00am (Giving a 24 hour window) any help on how to put this in as a criteria would be greatly appreciated

I'm trying to do an IF function that looks like this =IF($A$2="Name", Sheet2!A7:B18, IF($A$2="Name1", Sheet2!C7:C18, etc etc. A7:B18 Range - A7 and B7 are merged C7:C18 Range - C7 and D7 are merged and so on and so forth It's giving me a value error and I don't know how to create a VBA or...

I have the following in A1 "Floating/Personal Holiday (FPH)". I want to isolate only "FPH". I have the following formula: RIGHT(A1,LEN(A1)-FIND(" (",A1)-1) but it's giving me "FPH)". How do I isolate only "FPH"? Thank you in advance.

Hi team, I have a pivot table with a date range added under Filters in Pivot table which is giving me a non valid date ">28-08-17" as an option. when i select only that under filter i get nothing in the pivot table. please help me to get rid of this please..

Morning all, I have a list of dates in excel that look like the below (but there are around 4000 rows spanning a decade). I need to be able to filter by year and month to see employee start dates properly. However, I cannot do that as its not giving me the option of a date filter, only a text...