Results 1 to 8 of 8

Count multiple rows (text) with multiple criteria (text)

Threaded View

alecabral08 Count multiple rows (text)... 05-29-2008, 11:27 AM
NBVC In E5: ... 05-29-2008, 11:37 AM
alecabral08 hi! Thanks, though this... 05-29-2008, 02:00 PM
NBVC Just delete the last argument... 05-29-2008, 02:13 PM
alecabral08 Thanks a lot, that worked!!! 05-29-2008, 04:19 PM
alecabral08 Hi again :) As this... 07-21-2008, 03:47 PM
NBVC Just a matter of adding an... 07-21-2008, 03:59 PM
alecabral08 Thanks! I was missing one... 07-21-2008, 04:26 PM
  1. #6
    Registered User
    Join Date
    05-29-2008
    Posts
    14
    Hi again

    As this formula yo helped me with worked wonders in my dashboard, I decided to try and expand it´s use though it seems I am not good enough yet.

    In the same example I attached before, I added a "created" column (DataTable sheet) which indicates in which Fiscal Year this opportunity was created in our system.

    In the stats sheet I added 4 more columns: FY08 (U$S and quantity) and FY09 (U$S and quantity). I should be able to split the original values into these categories.

    i.e.:
    E5 should be the sum of G5 and I5.
    F5 should be the sum of H5 and J5.

    I know how to sum of course, but the question is what would be the formulas for G, I, H and J? I can´t use the original formulas that now count and sum in E and F, as those have no information on the created fiscal year.

    Thanks

    Ps: I´m attaching the modified example
    Attached Files Attached Files

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