Sumproduct question
Hello,
I have this forumal: =SUMPRODUCT((A5)*(N5="JS")) easy enough this works fine. My question is how on earth can I include another variable in this formula? I would like the resulting value of this formula to be divided by 2 if cell BU5 equals the number 1. Any ideas? Thanks, Chris |
Sumproduct question
Maybe...
=(SUMPRODUCT(A5*(N5="JS"))) / (if(bu5=1,2,1)) or dropping the =sumproduct() <it isn't necessary =(A5*(N5="JS")) / (if(bu5=1,2,1)) 0r even: =(A5*(N5="JS")) / (1+(bu5=1)) Chris wrote: Hello, I have this forumal: =SUMPRODUCT((A5)*(N5="JS")) easy enough this works fine. My question is how on earth can I include another variable in this formula? I would like the resulting value of this formula to be divided by 2 if cell BU5 equals the number 1. Any ideas? Thanks, Chris -- Dave Peterson |
All times are GMT +1. The time now is 12:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com