productif

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

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...

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...

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...

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...

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...

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...