{"id":30,"date":"2016-07-19T09:00:29","date_gmt":"2016-07-19T09:00:29","guid":{"rendered":"http:\/\/figartconsulting.com\/?p=30"},"modified":"2016-07-17T12:11:29","modified_gmt":"2016-07-17T12:11:29","slug":"nifty-tip-adding-or-subtracting-amounts-from-different-ranges","status":"publish","type":"post","link":"https:\/\/figartconsulting.com\/wordpress\/2016\/07\/19\/nifty-tip-adding-or-subtracting-amounts-from-different-ranges\/","title":{"rendered":"NIFTY TIP Adding or Subtracting Amounts from Different Ranges"},"content":{"rendered":"

Problem:<\/strong> You need to add or subtract amounts from different ranges according to a specific criteria (SUMIF function).<\/p>\n

Solution: <\/strong>Insert two SUMIF formulas and combine them into a single formula:<\/p>\n

    \n
  1. Insert the SUMIF formula to total the amounts based on the criterion 701 into cell E2.<\/li>\n
  2. Insert the SUMIF formula to total the amounts based on the criterion 300 into cell E3.<\/li>\n
  3. Select cell E2 and copy the formula from the Formula Bar, select the formula and press <ctrl>+C and click the Enter or Cancel symbol in the Formula Bar to exit Edit mode.<\/li>\n
  4. Select cell E5 and press <ctrl>+V.<\/li>\n
  5. Select cell E3 and copy the formula from the Formula Bar without the equals (=) sign by selecting the formula and pressing <ctrl>+C.<\/li>\n
  6. \n
    Select cell E5 and enter a minus(-) sign after the formula in the cell, and then press <ctrl>+V.<\/div>\n<\/li>\n<\/ol>\n

    The combined formula is now:<\/strong><\/p>\n

    =SUMIF(A:A,D2,B:B)-SUMIF(A:A,D3,B:B)
    \n<\/span><\/p>\n

    \"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

    Problem: You need to add or subtract amounts from different ranges according to a specific criteria (SUMIF function). Solution: Insert two SUMIF formulas and combine them into a single formula: Insert the SUMIF formula to total the amounts based on the criterion 701 into cell E2. Insert the SUMIF formula to total the amounts based … <\/p>\n

    Continue reading “NIFTY TIP Adding or Subtracting Amounts from Different Ranges”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":34,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[6,7],"class_list":["post-30","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-nifty-tips","tag-excel","tag-microsoft-office"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/figartconsulting.com\/wordpress\/wp-content\/uploads\/2016\/07\/Excel2016-e1468757638395.png?fit=418%2C410&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pLg3p-u","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts\/30","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/comments?post=30"}],"version-history":[{"count":2,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts\/30\/revisions"}],"predecessor-version":[{"id":33,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts\/30\/revisions\/33"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/media\/34"}],"wp:attachment":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/media?parent=30"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/categories?post=30"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/tags?post=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}