+ Reply to Thread
Results 1 to 2 of 2

Multiplying two columns and countif result is positive

  1. #1
    Registered User
    Join Date
    02-18-2022
    Location
    Sydney, New South Wales
    MS-Off Ver
    Office 365
    Posts
    37

    Multiplying two columns and countif result is positive

    Hi All

    Hopefully this is a simple one and I am just having brain fade

    I am looking to count the product of two columns when greater than zero and extra condition

    Column A is a reference (extra condition)
    Column B is a positive or negative
    Coulmn C is a positive or negative

    So I am looking to count when both B and C are positive or are both negative with a condition in Coumn A

    I have trying to use countifs combined with sumproduct, I know i can create extra column and use countifs but was hoping to tie it off without a column

    Appreciate any help

    Regards
    Last edited by GWCollo; 03-21-2022 at 09:51 AM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,173

    Re: Multiplying two columns and countif result is positive

    a sample sheet - see yellow banner would help a lot

    Negative
    =COUNTIFS(B2:B5,"<"&0,C2:C5,"<"&0)
    Positive
    =COUNTIFS(B2:B5,">="&0,C2:C5,">="&0)

    add the two together
    =COUNTIFS(B2:B5,">="&0,C2:C5,">="&0) + COUNTIFS(B2:B5,"<"&0,C2:C5,"<"&0)

    Add in the criteria for column A
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Countif on the result of a formula on 2 columns
    By krissysteen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2019, 09:20 AM
  2. Help with the result when I multiplying two numbers???
    By esopi in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-27-2016, 05:57 AM
  3. Multiplying by quanitity in parenthesis for COUNT result.
    By mchapa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2016, 06:42 PM
  4. [SOLVED] CountIf and then multiplying
    By Switchedit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2014, 07:03 PM
  5. if statement multiplying when the number is positive
    By fernandosaez in forum Excel General
    Replies: 6
    Last Post: 01-27-2011, 09:53 AM
  6. Multiplying then dividing the result of the multiplication
    By cbaker1615 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-08-2010, 04:09 PM
  7. Comparing columns then multiplying result by particular cell
    By raehippychick in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2008, 01:39 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