Results 1 to 5 of 5

SUMPRODUCT formula:pretty simple formulae

Threaded View

  1. #1
    Registered User
    Join Date
    02-16-2007
    Posts
    54

    SUMPRODUCT formula:pretty simple formulae

    I have a pretty simple formulae that matches a code in "Jan Timesheets" tab, column A against the code in the "Summary" tab, column A and totals the values for this match in timesheets column V, this reads as follows:

    =SUMIF('Jan Timesheets'!A:A,Summary!A14,'Jan Timesheets'!V:V)

    What i now want to do is bring this data across but not only matching code in Timesheets AA, but match with Timesheets AA and B:B equals 0100?

    Any help much appreciated, i'm still leaning formulaes as you can probably tell ...
    Last edited by VBA Noob; 05-22-2008 at 08:56 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