Using countifs in excel -


i have problem using function.the thing whatever do, counts 0. got 3 different sheets in excel different information in random people.what need is, compare different columns information had kind of criteria in it.

for example:

in sheet1 there column salary.

in sheet2 there max. salary can receive in current company, , yes/no column if paying taxes or not.

in sheet3 there 2 columns fee pays , loans have.

so need in sheet4 count how many of them receive salary $50 less or more max. one, pay loan $80 greater fee, , paying taxes.

i tried different things countif , countifs, shows me 0.thanks time.

option 1 - advanced filters

in order this, might @ useful alternative option .... advanced filters. advanced filters require aggregate data on 1 page, give power query on multiple criteria. here link advanced filter section microsoft excel 2010. great place start if want move outside of using basic formulas.

if go down route, follow directions on site in terms of steps:

  • insert various criteria have selected in top rows in spreadsheet , specify rows in list range

    • set criteria range place holding data on single worksheet

    • run filter , @ resulting data. can count on number of records in reduced data set.

enter image description here

option 2 - pivot tables

another option might @ here use pivot tables, although again, data have aggregated on 1 worksheet. pivot tables , pivot charts phenomenal tools use in workplace every day accomplish looking for.

option 3 - using visual basic

if adventurous, choose try using visual basic code write solution. give perfect control specify ranges @ each of conditions. unfortunately, need understand vb code in order use solution. there excellent online resources available can this.


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more