Search : in
By :

Open office, simple if then function help

Last answer on Oct 15, 2009 8:00:45 pm BST shortybookit, on Oct 15, 2009 6:13:27 pm BST 
 Report this message to moderators

Hello,
A2 through A50=date
B2 through B50=Store
C2 through C50=Type( A list of categories-Food,Gas,Fun,Dinning)
D2 through D50=Spent($ spent )

F10 should pull data
I want it to search through column C and look for all the rows that say gas flag them then add up the d column of the same row to see how much i spent on gas for that month

so f10= if column c =gas then add up money spent in corresponding d column so final result will be a dollar amount spent on gas if c says food it would not be included in the total.

Configuration: Windows Vista
Firefox 3.5.3

Best answers for « open office, simple if then function help » in :
Page numbering in Open Office Show Page numbering in Open Office Here's how to add page numbers in a document in Open Office: 1.Choose Insert - Footer and select the page style you want to add to the footer. 2.Place the cursor in the footer and choose Insert - Field -...
Convert excel vba code to open office star ba Show
Open a WPS File Show Open a WPS File Issue Solution Issue You have received a mail attachment in .wps, but you can not open it with Word or Open Office. Solution Just visit the site http://www.conv2pdf.com, which can convert .wps files into to...
[Excel 2003] - IF Function using Dates & Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Opening a PPS FILE ShowOpening a PPS FILE PPS, acronym for PowerPoint Show, is a tool created by Microsoft Office PowerPoint for distinguished presentations and slideshows. PowerPoint enables you to draft your own presentation within different display and design...
Counting the number of words in a document (Word or OpenOffice) ShowCounting the number of words in a document (Word or OpenOffice.org) Microsoft Word OpenOffice.org It is sometimes useful to count the number of words or characters in a document. The two major office suites can do it very...
Download OpenOffice ShowOpenOffice is a free office application suite, including a word processor, spreadsheet, presentation tool, drawing package and database, compatible with all other major office suites like Microsoft Office (97-2007 formats). Writer Calc ...
Download Open Workbench ShowOpen workbench is a free application of project management and scheduling. It is the free equivalent of Microsoft Project and has a simple interface and many features. It allows to define the life cycle of a project through a serial task. It...
Download OpenOffice.org ShowDescription: OpenOffice is a complete office suite. Features: It is ideal to replace Microsoft Office, in fact, it is compatible with all versions of Microsoft Office. Professional quality, the application offers all the tools necessary for the...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Hyperlinks ShowIntroduction to anchors Hypertext links or hyperlinks (anchors) are HTML elements that, when clicked on, enable readers to visit a new address. Hyperlinked text is underlined by default. Hyperlinks are what connect web pages to one another. They...
Spreadsheets - Worksheets ShowThe Concept of a Worksheet Spreadsheets display data and formulas in a table form (lines and columns) called a worksheet. A worksheet is made of lines (numbered with numbers) and of columns (numbered with letters). The intersection of a line and a...
Ask your question Reply

1

 shortybookit, on Oct 15, 2009 8:00:45 pm BST

Bump

   
Reply to shortybookit
Ask your question Reply
They need your help