|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 3rd, 2003, 05:18 PM
|
|||
|
|||
Functions
I have a spreadsheet done. Column D will let be marked
with an X if need to be ordered. Column E has price of said product. I would like the total to be at the bottom of Column D and only include the total of columns marked with an X. SO I need to refer the X to the price of the product in Column E. Can you pllleaaassseee help me!! I've tried and tried and can't figure it out. 
|
|
#2
October 3rd, 2003, 05:29 PM
|
|||
|
|||
|
Functions
Hi Dawn,
try =SUMIF(D2  100,"X",E2:E100)regards, Peo Sjoblom -----Original Message----- I have a spreadsheet done. Column D will let be marked with an X if need to be ordered. Column E has price of said product. I would like the total to be at the bottom of Column D and only include the total of columns marked with an X. SO I need to refer the X to the price of the product in Column E. Can you pllleaaassseee help me!! I've tried and tried and can't figure it out. .
|
|
#3
October 3rd, 2003, 05:38 PM
|
|||
|
|||
|
Functions
Look into the sumif function
-----Original Message----- I have a spreadsheet done. Column D will let be marked with an X if need to be ordered. Column E has price of said product. I would like the total to be at the bottom of Column D and only include the total of columns marked with an X. SO I need to refer the X to the price of the product in Column E. Can you pllleaaassseee help me!! I've tried and tried and can't figure it out. .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
