Register
Log In
Unanswered
Home
Dashboards
Xtreme Pivot Tables
Excel Customer Service
Excel Analysis Toolpak
December 16, 2016
Offline
Hi All,
As a recent new member this is my first post to the forum.
I am looking for a formula that will calculate a result based on whether all items meet a certain criteria.
Attached is the file which has a more detailed description of what I require along with the table of data.
Appreciate any help,
Thanks,
Adrian 
See Answer
Dashboards
June 25, 2016
Offline
Hi Adrian
See if this is what you want.
Sunny
Answers Post
July 3, 2016
Offline
Hi
Â
a first attempt
Â
in F5:
=IF(COUNTIF(D$5:D5,D5)>1,"",IF(COUNTIFS(D:D,D5,E:E,"Pass")=COUNTIF(D:D,D5),"Yippee!",IF(COUNTIFS(D:D,D5,E:E,"Fail")=COUNTIF(D:D,D5),"Oh no!","")))
Â
Regards
-----
Edit: sorry SunnyKow, I did not mean to overlap.Â
Most Users Ever Online: 57
Currently Online:
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Max Neumann
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
