Source: A1:B5
A1= 1 B1= 0
A2= 2 B2= 0
A3= 3 B3= 1
A4= 4 B4= 0
A5= 5 B5= 4
Question:
Looking for formula to multiply all value in A with 0 in B only
Per example, it will be 1*2*4
if I change the value in B5 to 0, it will be 1*2*4*5
thanks
Source: A1:B5
A1= 1 B1= 0
A2= 2 B2= 0
A3= 3 B3= 1
A4= 4 B4= 0
A5= 5 B5= 4
Question:
Looking for formula to multiply all value in A with 0 in B only
Per example, it will be 1*2*4
if I change the value in B5 to 0, it will be 1*2*4*5
thanks
Last edited by CAABYYC; 03-10-2016 at 03:24 PM.
This ARRAYED Formula will work
=PRODUCT(IF(B1:B5=0, A1:A5))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Questions?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks