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
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