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
|
|||
|
|||
sum using or (if Blank cell in Column)
My Basic problem seems to be that i cannot run a variable against a blank cell.
My set up as below: Item 50cl 70cl 1.5cl per 25ml ( answer i'm looking for) Rum £17.50 Cheese £80.35 Milk £10.50 Now individually i can work out these items. Rum would be 0.62 in the 25ml column... but I cannot find how to create each sum in the total box, so when i leave two of them blank it understand to only work out the one answer. It must look something like this? Right? Item 50cl 70cl 1.5cl per 25ml Rum £17.50 =sum(b2/20) (C2/28) (D2/60) Cheese £80.35 =sum(b3/20) (C3/28) (D3/60) Milk £10.50 =sum(b4/20) (C4/28) (D4/60) What am i missing in between each set of brackets to make the thing work though? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mozilla Firefox problem Please Hejp | shen923 | Publisher | 8 | May 16th, 2006 08:16 AM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
Using Validation to force entry into cells? | Mark | General Discussion | 16 | October 27th, 2004 09:23 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |