if statement - EXCEL - IF multiple strings in a range of cells - 


server type      count enterprise        3 standard          24 enterprise core   6

in excel, looking check if server type (a2-a5) contains both 'enterprise' , 'enterprise core' or 'enterprise'. if contains both, add 2 numbers together, otherwise, display number 'enterprise'.

perhaps this:

=sumif(a:a,"enterprise",b:b)+sumif(a:a,"enterprise core",b:b)

if doesn't have both .. it'll find 1 add ..


-

Comments

Post a Comment

Popular posts from this blog

Java 8 + Maven Javadoc plugin: Error fetching URL -

i attempting generate javadoc links javadoc dependencies. have tried various means generate javadoc not produce qualified class names references classes dependencies. wanted links java doc simplified class names. however, java api classnames, no links , have qualified class names. working java 8. have following configuration: <plugin> <groupid>org.apache.maven.plugins</groupid> <artifactid>maven-javadoc-plugin</artifactid> <version>2.10.2</version> <configuration> <reportoutputdirectory>${project.basedir}/target</reportoutputdirectory> <destdir>javadoc</destdir> <windowtitle>epiphany</windowtitle> <doctitle>epiphany</doctitle> <show>private</show> <detectlinks>false</detectlinks> <detectoffline...
Read more

c++ - Msgpack packing bools bug -

for c++ project use c++ msgpack library available in ubuntu (14.04) standard repository under name libmsgpack-dev. all works fine except when try pack bools. there things go absolutely bananas. first wrote simple test study pack method. turned out, can not trusted packing bools. here simple test showing problem: #include <msgpack.hpp> test_case("bool packing", "[msgpack1]") { msgpack::sbuffer buf; msgpack::packer<msgpack::sbuffer> p(&buf); std::string key = "boolvalue"; bool value = true; p.pack_map(1); { p.pack(key); p.pack(value); } msgpack::unpacked msg; msgpack::unpack(&msg, buf.data(), buf.size()); std::map<std::string, msgpack::object> m; msg.get().convert(&m); bool loaded_value; m.at(key).convert(&loaded_value); info("we packed: " << value); info("we loaded: " << loaded_value); r...
Read more

java - POJO with list of POJO to JSON display size and index -

so i've got 2 pojos: public class requestdisplayinfo { private int nombrepersonne; private string courrielorganisateur; private requeststatus statutdemande; private string salleassigne; getters/setters..... and public class requestsdisplayinfo { private list<requestdisplayinfo> acceptees = new arraylist<requestdisplayinfo>(); private list<requestdisplayinfo> autres = new arraylist<requestdisplayinfo>(); getters/setters..... when return second class, : { - acceptees: [1] 0: { organizeremail: "org" participants: 45 requeststatus: "accepted" roomname: "plt-2828" } - autres: [2] -0: { organizeremail: "org" participants: 2 requeststatus: "waiting" } -1: { organizeremail: ...
Read more