I have a cell that has either a 1 or a 0 in my spreadsheet its cell A1, if cell A1 is a 1 I want to add the sum of cells A3 through A7 and put this total in A2. If cell A1 is a 0 i want to insert a 0 in cell A2
I have a cell that has either a 1 or a 0 in my spreadsheet its cell A1, if cell A1 is a 1 I want to add the sum of cells A3 through A7 and put this total in A2. If cell A1 is a 0 i want to insert a 0 in cell A2
In A2
=If(A1=1,SUM(A3:A7),0)
Try
=SUM(A3:A7)*A1
Thanks for the responses, both worked thanks
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks