+ Reply to Thread
Results 1 to 6 of 6

COUNTIFS and SUMIFS formula help

  1. #1
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    COUNTIFS and SUMIFS formula help

    I have attached what I'm working on.

    I need H7 to look down column A for H5, look down column B for G7 and count the incidents.

    I need I7 to look down column A for H5, look down column B for G7, look down column E and add the incidents.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: COUNTIFS and SUMIFS formula help

    Hi

    H7
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I7
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Regard
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  3. #3
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Re: COUNTIFS and SUMIFS formula help

    Quote Originally Posted by micope21 View Post
    Hi

    H7
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I7
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Regard

    Thank you very much.

    One more small thing. Typing a number in H5 that appears in column A will bring up that number, what do I have to do to put in a * and get all the numbers for that month?

  4. #4
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: COUNTIFS and SUMIFS formula help

    Hi.

    No! It only pick up number match column A!!

    If you want to know total for that month? Cell I8
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Regard

  5. #5
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Re: COUNTIFS and SUMIFS formula help

    Quote Originally Posted by micope21 View Post
    Hi.

    No! It only pick up number match column A!!

    If you want to know total for that month? Cell I8
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Regard

    I can use that also, thank you again.

  6. #6
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: COUNTIFS and SUMIFS formula help

    You welcome!!

    Thank you for reputation!

    All the best!
    Regard

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] I can countifs a range but not sumifs
    By port in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-18-2014, 07:06 PM
  2. Need help in Excel SUMIFS + COUNTIFS
    By milehisweetipie in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-24-2013, 08:11 PM
  3. Sumifs/Countifs with multiple and's and or's
    By falcontrainer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-19-2013, 01:26 PM
  4. Sumifs, countifs 2007
    By somesoldiers in forum Excel General
    Replies: 1
    Last Post: 03-28-2011, 04:28 PM
  5. Sumifs and countifs
    By JohnGault82 in forum Excel General
    Replies: 3
    Last Post: 02-03-2011, 05:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1