productif

  1. E

    product equation for specific date range

    i am trying to use the product equation to product some values from certain date rang, i was thinking maybe there is some-sort of productif equation or so. thanks in advance
  2. E

    Formula to multiply two columns, if a 3rd column contains a certain word?

    I've looked around a lot for this but I can't seem to find anything that matches my exact situation. I'm working with stock exercises, and I want to sum up the amount of stock that was exercised. I have 3 columns: A- price per share, B- quantity exercised, and C- date exercised (which has...
  3. N

    Product if meets 2 criteria

    I'm trying to get the product of a range of numbers if it meets two criterion on a different tab. The formula below isn't working for me, can anyone see what I'm doing wrong? {=PRODUCT(IF(AND('Online Inputs'!$B$2:$B$337=S32,'Online Inputs'!$C$2:$C$337=T32),'Online Inputs'!E$2:E$337))} Thanks...
  4. S

    Which formula can I use? Is this possible?

    Hi All, I do not know which formula to use for what I am trying to acheive, so any help would be fab... I am tyring to put a formula in sheet 'sheet 4', cell A2, that says: if in sheet 1, "further Investigation" is in column D, and a figure greater than 0 is in column O,- then show me this...
  5. B

    Looking for PRODUCTIF() workaround

    I am having a hard time coming up with a good workaround for a PRODUCTIF() function. Here's the issue I'm trying to solve. I have over 1,000 rows of data with dates in Column A and values in Column O. I would like to multiply all of the values in Column O with the same date in Column A, and...
  6. H

    I need a "multiplyIF" formula...

    I work for a translation/interpretation company and I am trying to create a spreadsheet in which I can have the different services we provide multiplied by the rate we charge for that service. One column with the service (On-site, translation, ASL, etc.), another with the length of time. Each...
  7. W

    Do I need sumif/sumproduct/if? not sure Newbie

    Hi, Very new to excel. I have managed to manipulate a template to meet most of my needs, save one. On Sheet1 I need to multiply B1*10 if and only if F1 is found in sheet 3 or named list. i have been searching here and elsewhere for quite some time but have yet to find the solution to what i...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top