Friday, September 21, 2012

yogi_Find Conditional Sum Of Costs By Name Based On Entry Y In Column J Of Sheet Requests

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

2 comments:

  1. Need an iferror with this so the #n/a show as 0 untill applicable entries are added in 3rd sheet to sum up.
    Can you also remove link to spreadsheet, as after I finish sheet im gonna add some private data after that other admins can add, thanks :)

    ReplyDelete
  2. Hi Chris:

    I 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

    ReplyDelete