Search results

I am looking to put together an excel sheet to track attendance points throughout the year as a rolling 6 months. Simply excel sheet with Name in column A and Points in column G with Date in column F. Information will continue to be added to sheet. Can someone help me out?

I have below formula in which I believe it will take a point of after 181 days. So basically if someone got a point on January 2nd the point should come off July 3rd correct? I don't see the points coming off. Can anyone help...

I am trying to create a hyperlink between Test file and Bulk file. In Test file, PO # section is where I want the hyperlink to link to Bulk pick bins.xlsx file. Basically want to open up test file and click on PO # and the appropriate bulk pick bins excel file opens up with information. Thank you

=MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY())) I have the following formula in F2 cell. I would like to have this cell to show blank instead of zero.

How do you insert an automatic email command in excel? Need to have an automatic email sent to supervisor if say 4 total points are hit with information. I am in the process of creating a form to be sent but need to know how I set his up and then when form is completed, how to attach to auto...

Hi! I am looking to find out how to create a formula that will do a rolling 6 month point structure. Basically total point that can be accumulated in 6 months is 7. I want to have it take a point off when the 6 months is up. The point structure will be 1 thru 7 . It can be half points in there...

SELECT Tasks.* FROM Tasks WHERE (((Int([Due Date]))=Int(Date()))); Here is the logic. How would like to have this show information for 7days from due date?

I have a summary page with set up with Months listed on top and groups listed on left side. Below I have a drop down box which brings up each months information. I would like to be able to bring up January and have the information populate in summary section for January in upper section of...

=IF(E7&#62;0,SUM(E38+E18-E33),IF(E7,D38&#60;0,SUM(D39+E18-E33),IF(D38&#62;0,SUM(D38+E18-E33,0))) The above formula seems to not want to work. It tells me to many arguments but I am not sure why. If cell E7 is &#62;0 sum E38+E18-E33 If cell E7 and D38 is &#60;0 sum D39+E18-E33 If cell D38...

I have the following formula =IF(C46&#62;0,SUM(C45-C46)/C45,0) It works fine until I get across to cell I46 which is a negative number and comes up with 0.00%. How do I fix this one?

I have the below formula in worksheet. It works when there is information in C7 greater than 0.When I move across and C7 is less than 0 then it gives me false. What am I missing? =IF(C7&#62;0,SUM(C38+C18-C33-C29),IF(C7&#60;0,SUM(C18-C33-C29)))

I am having a brain freeze. What formula can I use to subtract positive and negative numbers. Example base # 8,000,000 - the following numbers below in cells. The issue is when I get to the last two calculations ( which are negative numbers), it is adding them instead of subtracting. My goal...

I am trying to figure out YTD by month Here is an example of spreadsheet remembering there are more columns with the rest of the months in it and a column for total and another for YTD at end. In total column shows formula =SUM(C7:N7) right now equaling 1,308,499 I am trying to right a...

I would like to find out how to write a formula and then understand what each section means. If C7 is &#62;0 add C7+C12+C13+C14+C15+C16; If C7 IS,0 add C8+C12+C13+C14+C15+C16.

I am trying to match up team name on sheet 1 to sheet 2 and if equal take number in sheet 2 and add to sheet 1. the formula is making me multiply the cell at end. It shows correct for first cell then when bringing down formula it shows it multiplying the numbers which i do not want to happen...