Results 1 to 3 of 3

Multiple criteria formula trouble

Threaded View

  1. #1
    Registered User
    Join Date
    07-19-2010
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    1

    Multiple criteria formula trouble

    Hello,

    I'm having trouble coming up with a formula.

    I wish to add #s in Column C if cells from Column A:

    Monday-Thursday and their corresponding amounts in Column B are =>500
    Friday and their corresponding amounts in Column B are =>1200
    Saturday and their corresponding amounts in Column B are =>2000
    Sunday and their corresponding amounts in Column B are =>600

    If each day's criteria are not met, I wish for a BLANK value return.

    A B C
    1 Thursday 400 5
    2 Friday 1300 6
    3 Saturday 2000 2
    4 Sunday 500 8
    5 Monday 450 4
    6 Tuesday 500 5
    7 Wednesday 600 8
    8 Thursday 550 3
    9 Friday 1100 2
    10 Saturday 2100 9
    11 Sunday 700 7
    12 Monday 300 8
    13 Tuesday 500 4
    14 Wednesday 400 4

    Any help is greatly appreciated!

    Thank you,

    WoWo
    Last edited by WoWo; 07-19-2010 at 09:38 PM. Reason: forgot something

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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