Friday, August 2, 2013

yogi_MultiConditional Sum From Data In Another Sheet

                                          Google Spreadsheet   Post  #1315
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 2013
user  Nancy Fletcher (http://productforums.google.com/forum/?zx=t4pky2oc4l45#!category-topic/docs/spreadsheets/P3mz4rz2B1k)
I want to Add some amounts IF a column = a value from another spreadsheet.
Sheet 1 is a summary sheet that has 
A        B             C
Year   Category  Summary of the Budget
2013   Hardware  "X"



Sheet 2 is a data entry sheet that has
A        B             C
Year   Category   Amount
2013   Hardware   $50000
2013   Hardware   $10000
2013   Prof Sec    $15000


IF Sheet2 A:A=Sheet1 "2013" and Sheet2 B:B=Sheet1 "Hardware" than ADD Sheet2 C Amounts $50000+$10000  and place the answer in Sheet1 column C for the value of X.

Does any know how I should write this folrumla?
---------------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment