+ Reply to Thread
Results 1 to 2 of 2

Need help with SUM functions please.

  1. 02-26-2013, 09:04 PM #1
    erpa2b
    erpa2b is offline
    Registered User
    Join Date
    02-26-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need help with SUM functions please.

    Forgive me if this is easy...I am fairly new to advanced Excel functions. I need to know if there is a way to apply a function to multiple columns in a row without having to do each row individually. I am writing a schedule with various positions on the same sheet, but I need to calculate how many of each position are on each day. As an example, if I have ten nurses in my department, each one taking a row between 1and 10, and my columns are 1-31 for days of the month next month, for the purpose of having it calculate how many nurses I have on each day after inputting their schedules how can I apply my SUMIF function for each day without having to go to each column and enter the function, choose the rows, etc. Is there a way to do this?
    Reply With QuoteRegister To Reply
  2. 02-26-2013, 09:18 PM #2
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Need help with SUM functions please.

    You can USUALLY use the auto referencing system in Excel to accomplish this..Absolute/Relative/Mixed

    If you need to maintain an absolute reference...like cellA2, in your formulas, you would use it like this $A$2
    if you need to keep a column reference, but the row changes (ie..when moving down a list), then use $A2
    if you need to keep a row reference, but the column changes as you copy across, then use A$2
    If the both change as you move the formula down/across, then you would use A2

    the first instance is ABSOLUTE addressing, it means that the formula will always reference that cell, no matter where the formula is moved to
    the second and third are MIXED addressing, meaning the row OR column will change as you move the formula down OR across
    the fourth is RELATIVE addresing, the row will change as you move formula down AND the column will change as you move the formula across

    Hope that helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1