excel formula

Posted on 2011-04-22
Last Modified: 2012-05-11
I am trying to use a formula in the attached excel example to check if a row contains a day of the week e.g. Monday,
Monday should be found twice in the example,  once the 2 rows are found, I would like the formula to add certain cells together in the Monday columns,

My proposed formulas do not work; can you please suggest any that will?


Question by:AlexAmbler
    LVL 30

    Expert Comment

    Try this

    LVL 30

    Accepted Solution

    Oops the attachment didn't come though


    Here it is again.


    Author Closing Comment

    thank you.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now