A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

sum using or (if Blank cell in Column)



 
 
Thread Tools Display Modes
  #1  
Old April 4th, 2006, 05:24 PM posted to microsoft.public.excel.newusers
external usenet poster
 
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
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 03:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.