LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dreadhead
 
Posts: n/a
Default 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 Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to index the first blank cell in a column of data Bruce Henson Excel Discussion (Misc queries) 3 February 23rd 06 08:07 PM
run a macro in a locked cell Ray Excel Discussion (Misc queries) 8 January 10th 06 12:02 AM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 06:19 PM


All times are GMT +1. The time now is 09:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"