Show all data when filtering on certain criteria

Hi,

I am creating a report to highlight fails from a set of raw data. I want to return the values of each fail section.

I have accomplished this using SUMPRODUCT formula but that limits me now to selecting a specific week of the data I also want to be able to show all the results on the same table but I am unsure if this is possible.

=SUMPRODUCT(--('Raw Data'!A:A=$B$8)*('Raw Data'!$J:$J=1))

As cell B8 is the week ending date I can now only show that weeks results I want to be able to view all results as well as a single week.

I can use COUNTIF to get the overall on another table but really want it on the one layout if possible. but then I can't get the weekly view.

=COUNTIF('Raw Data'!J:J,1)

I have attached my workings so far if anyone has any ideas it would be greatly appreciated. Not sure If I can combined these formulas in some way.

Thanks

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )