1/2/2018

Hello, Why am i getting #DIV/0! ??? =AVERAGEIFS($C$3:$C$40929,$B$3:$B$40929,$E3,$D$3:$D$40929,F$2) <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> 1 A B C D E F G H I J K L 2 Monday Tuesday Wednesday Thursday Friday Saturday Sunday Date...

Hello, While using the following formula i receive "#DIV0!" for the time stamp of 8:00 AM, what can i do to get the proper average in the column AA format =AVERAGEIFS($AA$3:$AA$40929,$Z$3:$Z$40929,$AC3,$AB$3:$AB$40929,AD$2) <tbody>...

I download a text file from my bank's website and I want to add all the deposits. The problem is the excel download has the dollar amount and text in the same cell and I cannot add the number because it has text. This is creating an unnecessary step for me because to solve this I would retype...

is it possible? Example data below. Basically, I want to build a formula that says on x date (01/02/2018), is there a value during the 7:00/8:00/9:00 hour? I've tried wildcards and lookups, but I think the format of the time is the biggest issue. I can get results if I enter as '7:32 vs...

Hey guys, Sorry, pretty new to this stuff so hopefully i can accurately describe what im trying to achieve. I need to have 3 rows for each DAY/NIGHT to filter through to more functions. At times, i only have 1 value for this shift so will need to insert 2 new rows to make things balance. I...

Below is a simple table. I would like to know of a formula that will look for the latest date within a row, taking into consideration of matching dates, and return the farthest right header. <colgroup><col><col span="4"></colgroup><tbody> Dates HD1 HD2 HD3 HD4 1st 1/1/2018 1/2/2018...

Hello ! I have a following formula here. I am trying to keep track of the latest transaction made. This is an Array Formula entered with Control+Shift+Enter. =MAX(IF($B$1:$B$4=$A8,IF($C$1:$C$4="Cu",$A$1:$A$4))) =MAX(IF($B$1:$B$4=$A8,IF($C$1:$C$4="Dp",$A$1:$A$4))) <tbody> A B C 1...

Here is a very simplified version of what I need help with. I'm trying to update dates people at my company put into our pto calendar in outlook in our availability spreadsheet. On one worksheet I have a list of names in Column A and a list of dates across Row 1. <tbody> 1/1/2018...