+ Reply to Thread
Results 1 to 3 of 3

If value of cell is > 0, multiple with the value in the same row - column b

  1. #1
    Registered User
    Join Date
    07-06-2018
    Location
    croatia
    MS-Off Ver
    2016
    Posts
    27

    If value of cell is > 0, multiple with the value in the same row - column b

    Is possible to make macro to count in some row is greater than 0 to multiple with the value in the same row in column B where is the price..
    To get what i need my formula looks like this..
    =C12*B12+C19*B19+C24*B24..
    And than do same thing like that in next .. column and then next... etc...
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-30-2019
    Location
    Hyderabad
    MS-Off Ver
    2010
    Posts
    18

    Re: If value of cell is > 0, multiple with the value in the same row - column b

    =sumproduct(($b$4:$b$32)*(c4:c32))

  3. #3
    Registered User
    Join Date
    07-06-2018
    Location
    croatia
    MS-Off Ver
    2016
    Posts
    27

    Re: If value of cell is > 0, multiple with the value in the same row - column b

    It works fine... thank you...

+ 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. VBA code for Add multiple Column cell Value in New Column Cell
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-24-2019, 04:40 PM
  2. Replies: 8
    Last Post: 07-26-2017, 07:53 PM
  3. Splitting cell/column in multiple column
    By rzhossain in forum Excel General
    Replies: 6
    Last Post: 04-17-2017, 08:00 AM
  4. Merging Multiple Sheet's column of data based on other column's cell value
    By BALA1983 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2017, 12:32 AM
  5. Select part of a cell in a column to multiple by another column cell
    By dadirtypanda in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2014, 03:57 PM
  6. Change Cell Value if multiple column value same
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2011, 10:39 AM
  7. Replies: 2
    Last Post: 05-01-2006, 12:00 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