Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Different cells that need to sum in one
Started 1 month, 3 weeks ago by Cbdavis
I have one cell that needs to contain the possible sum of cell (A1*B1) or (C1*D1) or (E1*F1) but only one of the 3 possibles For example : A1 is $10.00 B1 is QTY 1 Sum is $10.00 C1 is $8.00 D1 is QTY 1 Sum is $8.00 E1 is $7.00 F1 is QTY 1 Sum is $7.00 Also would be nice if I could allow only 2 of the cells to contain numbers at a time (A1 and B1) or (C1 And ...
Site: Microsoft Office (Excel, Word) forum - OfficeFrustration  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile
Forum: General Discussion  General Discussion - forum profile
Total authors: 2 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: officefrustration.com

Other posts in this thread:

Jacob Skaria replied 1 month, 3 weeks ago
--You can try the below formula. (all in one line) =IF(COUNT(A1:B1)=2,A1*B1,IF(COUNT(C1 1)=2,C1*D1, IF(COUNT(E1:F1)=2,E1*F1,0))) --Also to make sure you have only two numbers entered you can set data validation for this range.. Select A1:F1 . From menu DataValidationselect 'Custom' and copy paste the below formula. =COUNT($A$1:$F$1)3 If this post helps click Yes ---------------...
Size: 1,303 bytes
Customize:  Customize "<b>Reply 1</b>: Different cells that need to sum in one :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."

Cbdavis replied 1 month, 3 weeks ago
That worked Great ! What if I want to continue that formula in the next rows below that throughout the sheet? "Jacob Skaria" wrote: --You can try the below formula. (all in one line) =IF(COUNT(A1:B1)=2,A1*B1,IF(COUNT(C1 1)=2,C1*D1, IF(COUNT(E1:F1)=2,E1*F1,0))) --Also to make sure you have only two numbers entered you can set data validation for this range.. Select ...
Size: 1,575 bytes
Customize:  Customize "<b>Reply 2</b>: Different cells that need to sum in one :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."

Jacob Skaria replied 1 month, 3 weeks ago
--Copy the IF() formula down.. --Select the range and set the data validation...Slight change in the formula =COUNT($A1:$F1)3 If this post helps click Yes --------------- Jacob Skaria "Cbdavis" wrote: That worked Great ! What if I want to continue that formula in the next rows below that throughout the sheet? "Jacob Skaria" wrote: --You can try the ...
Size: 1,954 bytes
Customize:  Customize "<b>Reply 3</b>: Different cells that need to sum in one :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."

Cbdavis replied 1 month, 3 weeks ago
I can not get the validation to work correctly. It will not allow me to enter any value when I use the function below =COUNT($A$1:$F$1)3 Is it because there are cells in between the range I am using? I would like to have data entered in either F7, H7or J7 There is data in E7, G7 and I7 already "Jacob Skaria" wrote: --You can try the below formula. (all in ...
Size: 1,801 bytes
Customize:  Customize "<b>Reply 4</b>: Different cells that need to sum in one :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."

 

Top contributing authors

Name
Posts
Cbdavis
3
user's latest post:
Different cells that need to sum...
Published (2009-11-08 16:10:00)
I can not get the validation to work correctly. It will not allow me to enter any value when I use the function below =COUNT($A$1:$F$1)3 Is it because there are cells in between the range I am using? I would like to have data entered in either F7, H7or J7 There is data in E7, G7 and I7 already &quot;Jacob Skaria&quot; wrote: --You can try the below formula. (all in one line) =IF(COUNT(A1:B1)=2,A1*B1,IF(COUNT(C1 1)=2,C1*D1,...
Jacob Skaria
2
user's latest post:
Different cells that need to sum...
Published (2009-11-08 15:54:00)
--Copy the IF() formula down.. --Select the range and set the data validation...Slight change in the formula =COUNT($A1:$F1)3 If this post helps click Yes --------------- Jacob Skaria &quot;Cbdavis&quot; wrote: That worked Great ! What if I want to continue that formula in the next rows below that throughout the sheet? &quot;Jacob Skaria&quot; wrote: --You can try the below formula. (all in one line)...

Related threads on "Microsoft Office (Excel, Word) forum - OfficeFrustration":

Help with cells contents sum  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile Help with cells contents sum
Help with cells contents sum
Copying different cells from one list to another  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile Copying different cells from one list to another
Copying different cells from one list to another
Compare the value of one cell to 2 different cells  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile Compare the value of one cell to 2 different cells
Compare the value of one cell to 2 different cells
Auto populate different cells when selecting from drop...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Worksheet Functions - forum profile Auto populate different cells when selecting from drop down list.
Auto populate different cells when selecting from drop down list.
How do I format a cell based on conditions in five...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile How do I format a cell based on conditions in five different cells
How do I format a cell based on conditions in five different cells
Combining data from different cells and more...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Worksheet Functions - forum profile Combining data from different cells and more...
Combining data from different cells and more...
How do you attach multiple email addresses within...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile How do you attach multiple email addresses within different cells
How do you attach multiple email addresses within different cells
Comments disappearing, reappear, end up in different cells  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile Comments disappearing, reappear, end up in different cells
Comments disappearing, reappear, end up in different cells
Enter a number on different cells automatically ?  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Worksheet Functions - forum profile Enter a number on different cells automatically ?
Enter a number on different cells automatically ?
Conditional formatting based on different cells with more...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Worksheet Functions - forum profile Conditional formatting based on different cells with more conditio
Conditional formatting based on different cells with more conditio

Related threads on other sites:

Different cells that need to sum in one in...  Discussions in microsoft.public.excel.misc - site profile microsoft.public.excel.misc - forum profile Different cells that need to sum in one in microsoft.public.excel.misc
Different cells that need to sum in one in microsoft.public.excel.misc
Sum Different Cells In Different Sheets  Excel Help/VBA Help: - site profile Excel Help - forum profile Sum Different Cells In Different Sheets
Sum Different Cells In Different Sheets
Sum Different Cells From Different Worksheets  Excel Help/VBA Help: - site profile Excel Help - forum profile Sum Different Cells From Different Worksheets
Sum Different Cells From Different Worksheets
Matching Cells in different files to sum.  Lockergnome Forums - site profile Worksheet Functions - forum profile Matching Cells in different files to sum.
Matching Cells in different files to sum.
Sum cells based on varying conditions in different cells  MrExcel Message Board - site profile Excel Questions - forum profile Sum cells based on varying conditions in different cells
Sum cells based on varying conditions in different cells
Cumulative sum of different cells on different sheets  Excel Help Forum - site profile Excel Programming - forum profile Cumulative sum of different cells on different sheets
Cumulative sum of different cells on different sheets
Find 2 different cells in a certain column by name and...  MrExcel Message Board - site profile Excel Questions - forum profile Find 2 different cells in a certain column by name and put the sum of their values in another column
Find 2 different cells in a certain column by name and put the sum of their values in another column
Hey u guys i need sum more followers i wud like to thank...  Twitter / Brea10 - site profile Brea10 - forum profile Hey u guys i need sum more followers i wud like to thank the 1's i have may God bless yall but i need sum more please help me lol 6:59 PM Aug 20th from web
Hey u guys i need sum more followers i wud like to thank the 1's i have may God bless yall but i need sum more please help me lol 6:59 PM Aug 20th from web
Early morning walk through Chinatown. Amazing. Like a...  Twitter / Heyhelm - site profile Heyhelm - forum profile Early morning walk through Chinatown. Amazing. Like a different world. Need to come back later for dim sum. 7:00 AM Jun 27th from TweetDeck
Early morning walk through Chinatown. Amazing. Like a different world. Need to come back later for dim sum. 7:00 AM Jun 27th from TweetDeck
Thread profile page for "Different cells that need to sum in one" on http://www.officefrustration.com. This report page is a snippet summary view from a single thread "Different cells that need to sum in one", located on the Message Board at http://www.officefrustration.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity