# Excel 2003 :: How To Use Wildcard With SUMIF

Jan 3, 2013

I have looked and looked for how to use a wildcard with SUMIF (SUMPRODUCT, etc) to sum all numbers that start with 40, but I can not find the solutions to what seems like an easy problem with excel 2003.

In Column A I have numbers In column b values

89394 1
356778784 2
3456 3
400012 4
41788 5
123456 6
4010 7

What I want is =SUMIF(A1:A7,40*,B1:B7) = 11

## Excel 2003 :: Two Sumif In One Cell?

Sep 1, 2009

Using Excel 2003, is it possible to use 2 sumif functions in one cell?

i.e., sumif and sumif

## 2003: COUNTIF/SUMPRODUCT, Multiple Criteria W/Wildcard

Nov 24, 2008

I'm trying to write this but it returns a 0 when I know there are 3 records that match this criteria: =SUMPRODUCT(('Invoice-Detail'!J2:J50="NewJob_Post.NET")*('Invoice-Detail'!H2:H50="KY_*")). I think the problem is in the wildcard character. I don't know if I should be using COUNTIF or SUMPRODUCT or something else?

## SUMIF Multiple Criteria In 2003

Dec 15, 2009

I am using Excel 2003 and need help with sumif with 2 criteria. Please see attached worksheet.

I am trying to find total costs for repective projects if they happend in 2009 only, else leave blank.

In attached worksheet, see column c, row 17...thats what the result should be.

Find All Instances of:

Project A that happend in 2009 and from range c2..c7
Project B that happend in 2009 and from range c2..c7

etc.

and show their sum in c17,c18, etc.

## SUMIF With Multiple Criteria In 2003

Mar 4, 2009

I'm trying to return a value from a data dump based on 2 seperate criteria, 1 being the name of a person and the other being the name of an activity. Is there any way of using an array and the SUMIF function to do this?

## Excel Lookup With Wildcard?

Jun 20, 2012

I maintain a control list of all properties held by the company. Each month I have to manually review all property-related transactions (see transaction description column) and input in column "Key 1" the property it relates to by reviewing the data in the transaction description and finding the property in the control list. Is there a way I can automate this process with a forumla?

some key points:
- the name in the control list can appear at any positiion in the transaction description
- various transactions relating to the same property will appear in the transaction description listing many times and key 1 will need to be completed against each entry
- if there is no match between the transaction descripton and the control list then the relevant cell in column "Key 1" should show as "Not Found"

Control List
Transaction Description
Key 1
Bligh

[Code].....

## Lookup Formula With Wildcard: Force Excel To See * & ? As Characters

Sep 8, 2006

There might be an easy solution for this, but I can't seem to figure it out. I'm trying to do a vlookup with the lookup value being #CFDMSMCSA*4. But the lookup table also has a value #CFDMSMCSAM4 in it.
It keeps returning the value for this #CFDMSMCSAM4 because of the * in the first string. Any ideas.

## Excel 2010 :: Macro With Autofilter With Array To Remove Unwanted Criteria With Wildcard

Apr 28, 2014

I'm having a hard time making this maro work in Excel 2010.

I need it to filter out the items "AR", "BATCH", and the line of "Total:*" where the * is a total amount of any given number dependant on the day.

Below is the coding I have that Excel is not liking.

Sub FilterAccurateRawData()
'
' FilterAccurateRawData Macro
'
'
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("\$A\$1:\$AA\$45415").AutoFilter Field:=1, Criteria1:=Array("<>AR", "<>BATCH", "<>Total:*")
Operator:=xlFilterValues
Sheets("Instructions").Select
Range("A9").Select
End Sub

## Excel 2010 :: VBA Code That Handles Several Specific Parameters Or Wildcard Passed To Access

Jul 17, 2013

I would like to develop a user-friendly Excel 2010 spreadsheet that would allow the user to enter from 1 to 10 (i just picked this number at random just to have an upper limit) employee numbers in cells A1-A10 and "click" on the VBA Code button that would invoke an Access Query and in the process return all the applicable data gathered from the query back into the Excel Spreadsheet. Believe it or not, I can do all this mentioned so far. BUT what i cant do is my second option for the user which is allow them to pull ALL of the employees back into the spreadsheet using the same query.

In summary, using Excel as a frontend dashboard, I know how to get a specific number of employees' information from a query and I know how to get all employees' information from a query but I dont know how to get either/or. In other words, I could do this with two queries and two "VBA-Code" buttons but I would like to do it with one query and one button.

## Excel 2003 :: Copy Hyperlink From Excel To Outlook?

Apr 19, 2010

I have an Excel 2003 file that contains hyperlinks to OneNote notebooks on a Sharepoint site. An Excel macro looks for these links and determines the full hyperlink address which is then assigned to a variable. An Outlook message is generated which includes the hyperlinks.

The hyperlinks work in the Excel file. I can also copy them from OneNote and manually paste them into an Outlook message and they work. However, when I obtain their full address and transfer that to the email through code, the links do not work. The hyperlink address from OneNote starts with "onenote:http" which is not recognized as a link.

If I can do this manually, there must be a way to do this with vba. Are there characters I need to include in the OneNote hyperlink address to make this work? Is there another way to transfer the working link from Excel to Outlook?

## Adjust Macro From Excel 2003 To Excel 2010?

Apr 1, 2014

I am trying to adjust the below macro so that it will work in Excel 2010.

Sub OpenAndProcess()
Dim fs As FileSearch
Dim I As Integer

[Code]....

## Excel Bug ? For SUMIF

Dec 15, 2008

I am writing the sumif function in F2 but it is not working correctly..

## Excel 2003 :: Alt + F11 Key Not Working?

Feb 21, 2012

when I use the above key stoke nothing happens in excel. It won't get me into vba editor??

using Dell laptopInspiron N4010 and office 2003

## Excel 2003 :: Hiding 0 Using ABS

Mar 27, 2012

I am using the formula ABS(D6-G6) when these cells are empty I get a 0 result, how can I get rid of this?

Using 2003

## Excel 2010 :: SUMIF With Multiple Variables?

Dec 9, 2013

Excel 2010 Windows 7

There is a lot going on, including a check box, which I dont have much experience with and data on two different sheets. I need to sumif the box is checked (true cell) and the item matches the item on another sheet then I need to sum the qty in the adjacent column.

Inventory sheet:

I will have a similar formula in both C and D, but this will be for what I need in D, and I should be able to figure C out from that. What I have to get my starting number is "=SUM('Proc-Pack SUMMARY'!B16-'Proc-Pack SUMMARY'!C16)". Now I need to subtract what is sold from that number to give me a current on hand number.

Type
date
qty packaged
qty bulk

Inventory sold sheet:

The type column is a drop down box with that matches the type column on the inv sheet. The "cyl" and "lbs" columns have check boxes in them. So if C (cyl) is checked and A matches A on the inventory sheet I need to subtract D.

Type
Cyl
Lbs
Qty

Ive tried various variations of this "=SUM('Proc-Pack SUMMARY'!B16-'Proc-Pack SUMMARY'!C16)-sumif(Sold!F:F,"true",Sold!E:E=Inventory!A:A,Sold!H)"

Also is it possible to link so you can only one of the two check boxes in a row? I know the option button does this, but I didnt think that would work with the formula.

## Excel 2003 :: Group And Outline

May 14, 2013

In Excel 2003 I have Manually Grouped a number of rows. (Data>Group and Outline>Group).

If I use the buttons with the numbers 1, 2, 3 (indicating an outlining level) to collapse or expand the outline I receive the Error Message: "Cannot shift objects off sheet."

If I use the collapse button (-) or expand (+) button the data collapses and expands as I would expect.

I am aware of the normal issues surrounding objects and outlining and have ensured that I have changed the properties of all my of the objects in the sheet to "Move and size with cells". There are no comments in the grouped rows.

## Excel 2003 :: Formula To Sum Every 6th Row Of E Column?

Feb 4, 2014

The following formula was, several weeks ago, very graciously offered to me from one of Excel Forum's contributors.

=SUMPRODUCT(--(MOD(ROW(E8:E6782),2)=0),E8:E6782)

My request was to find a formula that would add each 6th row starting in row e8 (e8+e14+e20+e26+e32 etc. through e6782) in column "e" when the column was 6782 rows deep from top to bottom. (i am not trying to add every number in column e, just each 6th row, starting at e8 and going through row e6782).

I entered the formula into my spread sheet and, voila, I had a sum that I assumed was accurate for my spread sheet of ticket sales. I began to question the functionality of the formula when I altered the E8:E6782 parameters (which represented the gross ticket sales) to E4:E6778, in an effort to sum up the E4 values e4,e10,e16, e22,e28,etc. . . (which represents the net values after commissions were deducted). The difference in the two sums (e8 values Versus the e4 values) was incorrect and did not represent the appropriate commissions (which should have been 15%).

## Excel 2003 :: Log Out Duration Per Employee

Feb 27, 2014

I have a Log In/Log Out report that I need pulling data from.

Ultimately what I want to do is get the amount of time my employees were logged out.

I am using Excel 2003. Attached is an example of the data I'm working with.

Sheet 1 contains the data, and Sheet 2 will be the summary.

So, looking at Bob's times: If column A contains Bob (A2 in this case), and the same row in column G (G2) contains 79, subtract the contents of the same row in column F (F2) from the next row down in column D (D3) (which would be D3 - F2). That result should populate on Sheet 2 next to Bob's name in h:mm:ss format.

If there is nothing in the next row down in column D, then do nothing.

I would like to leave the data as is, if possible. There are extension numbers next to the names in the data. If possible to ignore those when rolling up to the summary that would be useful. Also, on the summary sheet, if the employee is not on the data sheet (if they had the day off) they can have 0 or NA or something to indicate there is no data for them.

## Excel 2003 :: Status Bar Missing?

Apr 15, 2014

In Excel 2003 the Status Bar is missing. I know to go to Tools, Options, View to view and hide the Status Bar however as i cannot see Tools (as Status Bar missing) is there another way to get the Status Bar back?

## Excel 2003 :: Can't Retrieve XL Documents

Jul 18, 2013

I have used MS Office Excel 2003 for many years without difficulty in XP. Suddenly I find I can't open many of my old documents. I get a message,"Microsoft Office (InfoPath2003) cannot open (the following file, etc.) A second message says, "The form contains XML that is not parsed: An invalid character was found in the content. Line 0, Position 0" Then I get the message "MS Office is not currently set as default." I complete the instructions that follow and it is now corrected but I continue to get the same error messages.

## Excel 2003 :: Undo Is Not Working

Nov 12, 2013

why my undo just won't ever work. Excel 2003.

## Excel 2003 :: SaveAs VBA To Always Save In XLS

Mar 11, 2014

I am trying to edit the code below to save in .xls instead of .xlsm. Also, I need to disable the compatibly checker.

[Code]....

## Excel 2003 :: How To Automate A Macro

Oct 27, 2011

I am running Excel 2003.I have a spreadsheet with two worksheets, each worksheet has a Refresh button that runs a Data Extract Macro.The Data Extract Macro imports Data from another spreadsheet.I want to have the spreadsheet automatically run my Data Extract Macros for both worksheets at a specific time each week. (Scheduled task) Regardless of whether or not the excel file is open.

## Excel 2003 :: Carriage Return For Row?

Oct 28, 2011

In Excel 2003, I remember being able to tab across a row of cell entering data and when I got to the end, I'd hit enter and it would take me to the beginning of the next row. But in 2007, I can't...is there something I need to do in Excel Options or is this function gone?

## Excel 2003 :: How To Merge Several Worksheets

Nov 21, 2011

I would like to merge several sheets into one sheet, all from within the same workbook. All sheets have the same data layout. I use xl 2003.

How can I merge them all into a single worksheet?

## Excel 2003 :: Matching Row Data

Nov 28, 2011

I have five columns of data: A & C are time measures; B & D are values associated with each time measure; and E is a matching value column that I want to populate. I am trying to match times and place in col E the Val 2 that matches times 1 and 2. Though many matches lie on the same row, there are many that don't (the real data uses several thousand rows). For example, Val 1 in cell A5 (100) is associated with cell C7 to find a matching value of 4.5 in cell E5. Note, occasionally, there will be replicate values for Val 2 (like cells C9 & C10). I need to match the one further down the list.

Excel 2003ABCDE1Time 1Val 1Time 2Val 2Match203.902.72.73484.7482.12.14545492.33.351006543.34.562003554.472192.71004.57.782015.592196.6102197.7Sheet1

## Excel 2003 :: Cannot Unhide Column

Nov 30, 2011

I have an Excel 2003 application where one of the columns (column D) has been hidden by some user.

When I try to unhide nothing happens. I select column C and E followed by a right-click on column E where I choose Unhide -> column D stays hidden.

## Excel 2003 :: Return Last Instance?

Jan 3, 2012

I have tried Index/Match but nothing so far. Basically, I have this table:

Sheet2KLMN3Employee1Client Assistance/Request31/3/2012 14:57:344Employee1Client Assistance/Request31/3/2012 14:58:075Employee2Client Assistance/Request11/3/2012 14:59:456Employee3Client Assistance/Request11/3/2012 17:08:297Employee1Client Assistance/Request61/3/2012 17:10:16Excel 2003

So now, I want E19 of the table below to bring back column N of sheet 1, but only the last instance in which those Employee 1 and Client Assistance/Request met. In this example N7 of Sheet 2.

Sheet1BCDE18Client Assistance/RequestDate19Employee 10020Employee200Excel 2003

## Excel 2003 :: Get Some Information To Stay Still?

Jan 29, 2012

While using Excel 2003, I am aware of "freeze plane" and "split worksheet". The freeze plane comes in handy if I want to the first few rows to remain stationary and displayed while I can scroll down to the rows below. Similarly, the split worksheet comes in useful if I want to have the first few columns remain in place while I can maneuver to the right to see the other columns.

*** THE QUESTION IS: how can I get cells A1 to F20 to remain displayed and unmoved even if I choose to move the active cell around anywhere between G1 to K9999

## Excel 2003 :: Convert PS File To PDF?

May 24, 2012

Every day I create many Excel reports that I manually save as PDFs for distribution to my stakeholders. I'd like to automate this process using a macro. I've seen the following code online and have attempted to use it, but receive an error in the Dim MyPDF line of code indicating that the user-defined type is not defined.

I'm using Excel 2003 and Acrobat Distiller 8. I have no problem creating PDFs manually

Code:
Sub Create_PDF()
Dim tempPDFFileName As String
Dim tempPSFileName As String
Dim tempPDFRawFileName As String

[Code]....