Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #771 Sep 21, 2012 www.energyefficientbuild.com.
user Chrisnetika said: (http://productforums.google.com/forum/?zx=vay6zqqzi38u#!category-topic/docs/spreadsheets/zmt3unYQNQM)
Sum and IF
On one sheet I want to track spending of ocho that is linked to another sheet that has transactions.I want it in a sense where user has a balance and on another sheet thru lookup it takes all transaction that user is in and subtracts the cost and shows current balance.Obstacle is if I have a transaction with sent = n or blank then I dont want it to be counted in spent unless there is a Y.Method im trying is.. if it doesnt have a Y and is blank.. it turns total spent to false , and if I set statement where if it is blank or n to then be 0 .. even if any other transaction has a Y it will keep show total spent as ... 0 I have 1 transaction that is N and another that is Y .
----
Sheet
sample data as shown
and other sheet that is tracking what is spent is in requests.
I dont want transaction to use their balance unless it is sent via Y in Sent? column
--------------------------------------------------------------------------------------------------
following is a solution to the problem
user Chrisnetika said: (http://productforums.google.com/forum/?zx=vay6zqqzi38u#!category-topic/docs/spreadsheets/zmt3unYQNQM)
Sum and IF
On one sheet I want to track spending of ocho that is linked to another sheet that has transactions.I want it in a sense where user has a balance and on another sheet thru lookup it takes all transaction that user is in and subtracts the cost and shows current balance.Obstacle is if I have a transaction with sent = n or blank then I dont want it to be counted in spent unless there is a Y.Method im trying is.. if it doesnt have a Y and is blank.. it turns total spent to false , and if I set statement where if it is blank or n to then be 0 .. even if any other transaction has a Y it will keep show total spent as ... 0 I have 1 transaction that is N and another that is Y .
----
Sheet
sample data as shown
and other sheet that is tracking what is spent is in requests.
I dont want transaction to use their balance unless it is sent via Y in Sent? column
--------------------------------------------------------------------------------------------------
following is a solution to the problem
Need an iferror with this so the #n/a show as 0 untill applicable entries are added in 3rd sheet to sum up.
ReplyDeleteCan you also remove link to spreadsheet, as after I finish sheet im gonna add some private data after that other admins can add, thanks :)
Hi Chris:
ReplyDeleteI have enhanced the illustration to show that there is no need for incorporating the IFERROR function call.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com