Results 1 to 5 of 5

Multiple calculations in one SUMIF formula across multiple worksheets

Threaded View

necht_angel Multiple calculations in one... 11-14-2011, 10:42 AM
NBVC Re: Multiple calculations in... 11-14-2011, 12:06 PM
necht_angel Re: Multiple calculations in... 11-14-2011, 12:50 PM
NBVC Re: Multiple calculations in... 11-14-2011, 01:34 PM
necht_angel Re: Multiple calculations in... 11-15-2011, 05:30 AM
  1. #1
    Registered User
    Join Date
    09-21-2011
    Location
    London
    MS-Off Ver
    365
    Posts
    71

    Multiple calculations in one SUMIF formula across multiple worksheets

    Hi there, I hope you can help, although this seems quite complicated and I'm not sure it can be done.

    Basically I have two corresponding worksheets with information contributing to the formula, and the formulae needs to calculate this information multiple times (possibly across 50 columns).

    I have attached a sample which I 'hope' will explain it better than I have. (only the first two yellow sheets are relevant to the calulations)

    I would be really grateful for any advice on this one. I am not particularly technically minded so 'dummy' language may be required lol

    Thanks all
    Attached Files Attached Files
    Last edited by necht_angel; 11-15-2011 at 05:30 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1