• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

excel formula

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?

Regards

Example.xlsx
0
AlexAmbler
Asked:
AlexAmbler
  • 2
1 Solution
 
SiddharthRoutCommented:
Try this

Sid
0
 
SiddharthRoutCommented:
Oops the attachment didn't come though

=SUMPRODUCT((B2:O2="Monday")*(B5:O5))

Here it is again.

Sid
Formula.xlsx
0
 
AlexAmblerAuthor Commented:
thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now