Just as a note I am unable to upload any example files, hopefully this is easy enough to explain without the need of an example file.
I am trying to make a COUNTIFS formula which looks for certain criteria in 3 columns, one of those columns however is looking for mutiple criteria.
This is what my formula looks like (which isn't working)
So I want to count only the rows which have "Scotland" in J, "Recovered" in D and P1 or P2 in B.
Please Login or Register to view this content.
Last edited by Janbi; 12-23-2016 at 04:54 AM.
Try:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Or try this ...
=SUM(COUNTIFS($J$2:$J$500,"Scotland",$D$2:$D$500,"Recovered",$B$2:$B$500,{"P1","P2"}))
Originally Posted by Olly
Try:
Formula:Please Login or Register to view this content.
Thank you worked perfectly.
Last edited by Janbi; 12-23-2016 at 04:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks