Select multiple cells to perform product

**marcrg** · 10-26-2022, 09:37 AM

Hello

Help!

Is there a formula/function that will enable me to find the product of all the values between two of the dates. for example, in the table below I may need it for from 2020 to 2022 so I'll need a formula that will give me 108.6*109.4*117.1.

Date Value
01/03/2022 117.1
01/03/2021 109.4
01/03/2020 108.6
01/03/2019 107
01/03/2018 105
01/03/2017 102.5
01/03/2016 100.2
01/03/2015 99.7
01/03/2014 99.7
01/03/2013 98.1
01/03/2012 95.4

I effectively need something where I can tell it the two dates, and it will give me the product of all the values between those two dates. I thought it would be as easy as using the CELL function to get the cell names into the PRODUCT function but I can't seem to get that to work

Sorry if I'm not making this clear - any help will be greatly appreciated!

Thanks!

**AliGW** · 10-26-2022, 09:43 AM

Welcome to the forum.

Next time, please provide a sample workbook.

Try this:

=SUMPRODUCT(($A$1:$A$11>=DATE(2020,1,1))*($A$1:$A$11<=DATE(2022,12,31))*$B$1:$B$11)

**AliGW** · 10-26-2022, 09:54 AM

Or use SUMIFS:

=SUMIFS($B$1:$B$11,$A$1:$A$11,">="&DATE(2020,1,1),$A$1:$A$11,"<="&DATE(2022,12,31))

Any good?

**AliGW** · 10-26-2022, 10:08 AM

Seen, but no response ...

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

**marcrg** · 10-26-2022, 10:08 AM

Hi,

Thanks for looking at that for me.

Both of those give me the sum of the values rather than the product. It is picking up the values I want though.

Thanks

**AliGW** · 10-26-2022, 10:09 AM

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

**AliGW** · 10-26-2022, 10:15 AM

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...oduct.1220350/)

**marcrg** · 10-26-2022, 10:15 AM

Example workbook.xlsx

Sorry! Hopefully that's worked

**marcrg** · 10-26-2022, 10:31 AM

Hi,

Someone on another forum gave me this which seems to do the trick.

=PRODUCT(IF((YEAR(A2:A12)>=2020)*(YEAR(A2:A12)<=2022),B2:B12))

Thank you though

**AliGW** · 10-26-2022, 10:38 AM

Have you read post #7 and do you understand it?

Please make sure you read through our rules (to which you agreed on joining) before you next post here. Thanks.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

**marcrg** · 10-26-2022, 10:38 AM

Sorry - I was told off for this on the other forum too. Won't happen again.

**AliGW** · 10-26-2022, 10:39 AM

Please mark as solved, etc. as explained in post #10.

Select multiple cells to perform product

LinkBack

Thread Tools

Rate This Thread

Display

Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Re: Select multiple cells to perform product

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] how to select cells above active cell and do a sum product with other row in VBA

Need to perform operation if multiple cells are blank or nonblank

[SOLVED] Help With VBA Macro to select cells with certain value and perform action on adjacent cell

Select Multiple workbooks at once to perform an action

Select Multiple workbooks at once to perform an action

[SOLVED] Select multiple independent cells and perform a calculation

[SOLVED] how to select specific cells to product a chart

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions