spreadsheet

  1. L

    Solved SUMIFS help

    I need help coming up with an excel formula I'm not sure if I need a SUMIF, SUMIFS or some other formula. Each patient is assigned codes (B2:E2) and each code has a value (A5:B11). I need to add up the total value for each patient. The example below only gives a total of one code (in C2)...
  2. T

    Emailing from Excel

    hi guys ive scoured the net and this is as close to the answer i need hope you guys can help. I am looking to have excel filled out with the following: name.......start date..........due date but then somehow vba this to email outlook say 2 days prior to the due date to remind staff to complete...
  3. F

    Solved IF Statement

    Hi there, I can't figure out how to properly write an IF statement for this specific scenario. I have to calculate E.I (Employment Insurance). E.I is 1.27% of your gross income. If my annual gross income is for example $66'000 I'd type in the formula =(C7*1.27)/100 (C7 is the cell with...
  4. F

    Simple interactive Excel spreadsheet

    I'm trying to create a simple interactive spreadsheet for a club that I run in a local school. We sell food at this club and, because children inevitably lose money throughout the day, their parents have sent us funds in advance. We are therefore looking at the simplest way of keeping track of...
  5. L

    Spreadsheet Help

    Heyo people! I need to start printing and cutting out 6,000 squares, STARTING TOMORROW. Before I do anything though, I need to have the template ready -- and I don't. I have done it on paper and know that I need .25" margins, 12 2.25" squares per page, and an extra slip that is 1.25". When I try...
  6. M

    Linking a form to database in excel

    HI guys, I need to create a form in excel which, after the fields were filled out and submitted, the data would update a dynamically linked Excel database file. For example, my form might have three fields: Name, product and quantity. My Excel file would also have three columns titled name...
  7. A

    Solved Excel automatic mail

    hi everyone, this is my first post on techguy. I really need help with a Microsoft Excel spreadsheet. The workbook consists of gauge numbers and their calibration due dates. Can someone please help me so that Microsoft Excel automatically sends a mail to a particular email address when the due...
Top