Question about Microsoft Computers & Internet

# I am using excel and trying to make a formula to add up the values in column C only if the value in column D = a specific task i.e. column C5 = 10 D5 = patrol time C6 = 10 D6 = complaints C7 = 15 D7 = patrol time. I thought the formula to pull only the time spent on patrol should look like this: =sum(c5:c37)if[inputs!d5:d37=patrol time] but this isn't working.

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Governor:

An expert whose answer gotĀ voted for 20 times.

Scholar:

An expert who has written 20 answers of more than 400 characters.

• Expert

For this you are going to need a macro, you might be able to finesse it into doing it without one but for ease of use and best results I would recommend a macro code; I could give you a basic rundown of how to do it but I think the best way would be to have you send me a generic setup of your spreadsheet and I would be happy to throw the code together. It is basically going to be a a few If else statements with a loop. My email addy is kustom42 at gmail.com, I'll set you up and have it working in a day if you think this is a good solution worthy of 4 thumbs :)

Posted on Jul 14, 2009

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
New users get 2 Free calls (no credit card required) and instant help on almost anything you can think of (from cars to computers, appliances, handyman, and even pets).
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How do i subtract two cells and progress down a row by a day so the next day the formula subtracts the current day and previous day?

You have to start the sequence with a slightly different formula because there is no preceding value for Monday.
The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.
Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

Mar 06, 2015 | Microsoft Excel 2010

### In Excel adding positive and negative numbers

Yes,

1. Select the column. (click on top of the column it will select)
2. Right Click and select Format Cells.
3. Select Currency in Category then press OK
Now just type your Numbers i.e. 571 for \$571 and -650 for -\$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

### How to calculate next sequential number using multiple columns

Try using a formula like this in Col AI:

=IF(AG9<>1,0,MAX(AI\$1:AI8)+1)

A couple of notes:
1. You'll need to adjust the references for this formula in the first row of each new column you use.
2. If you don't want Zeros for the cells that don't increment, the you can use "" instead to get blanks.

Apr 25, 2014 | Microsoft Excel for PC

### Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

### Excel formula

Dalenh,
in Excel this problem dosent come normally if we set cell format to general type.
However, if you want, you can try following :-

=value(Cell1)-value(cell2)

Zulfikar Ali
09899780221

Nov 02, 2008 | Microsoft Computers & Internet

### Excel will not displaying the results of a trend array formula

Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

### Help

go to page setup and under scaling you can adjust to your required percentage

Jul 22, 2008 | Microsoft Excel for PC

### Copying data from one sheet to another if two fileds match

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):
A1: Part B1: Code C1: Price D1: Find Part E1: Find Code
A2: x B2: 11 C2: 5.00 D2: y E2: 12
A3: x B3: 12 C3: 6.00 D3: y E3: 11
A4: y B4: 11 C4: 7.00 D4: x E4: 12
A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:
=INDEX(\$C\$2:\$C\$5,MATCH(D2,IF(\$B\$2:\$B\$5=E2,\$A\$2:\$A\$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft Computers & Internet

### Excel 2002 formula

Try this:

=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))

Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.

Dec 03, 2007 | Computers & Internet

## Open Questions:

#### Related Topics:

59 people viewed this question

Level 3 Expert

Level 3 Expert