Hi

I am trying to tie one cell into a formula that is being pasted into multiple rows.

I know you can use $ to keep the cell consistent but it doesn't seem to be working.

So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the column.

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link __ http://downloadreimage.com/download.php__. (This link will automatically start a download of Reimage that you can save to your computer.)

You use $C9 to keep the column consistent, C$9 to keep the row consistent and $C$9 to keep the cell consistent. Are you doing that and it's not working?

Read other 2 answersFor some reason I cannot get Excel 2000 to display the results of a formula. Only the formula text displays. I've gone to Tools-Options-View-Windows Options and checked and unchecked the Formulas checkbox. It doesn't make any difference.

Help!

Thanks,

Thomas

Format the cell as a number, it prolly is fmt'd as text

Hi ~

I'm working on a financial formula, trying to calculate a growth rate for a row of cells. The problem is that not all rows have complete data sets, so the formula picks up blank cells and returns a #DIV/0! error.

The existing formula works fine for those rows that have non-zero entries in all cells, and I *can* manually adjust the formula for the starting / ending cells in each row--but what a pain(!). As this spreadsheet grows larger, or the data sets change over time, it means I have to constantly keep adjusting it for every row of data involved, which is extremely time-consuming.

Here's an short example of what I might have in any given row:

A1 (blank), B1(blank), C1(blank), D1(.10), E1(.25), F1(.72), G1(1.0), H1(.80), I1(.60), J1(.75)--then in K1 is the growth formula, e.g. =((J1/A1)^(1/10)-1).

Is there ANY way to create a formula that will dynamically adjust for the blank cells that might exist across a row of data and let the formula do the calculation?

I'm new to advanced Excel topics, but any ideas would be MOST appreciated(!).

Thanks -

CP

Hi, I need to do the following:

Search array

1 a 12 asdas

2 b 121 agrsfsa

3 c 3 qwgds

4 b 131 erwer

5 e 4123 q3eqt

need to return something like this

lookup value b

answer should look like this

2 b 121 agrsfsa

4 b 131 erwer

index, match can give me one row, however what could return multiple values

Thanks in advance for your help.

Cheers

Read other 8 answers

If it's possible to do this, what is the formula syntax for an if/then formula in one sheet that refers to the cell value in another sheet in the same workbook?

For example in Sheet 2, the formula would be something like, if Cell A10 in Sheet 1 is greater than 0, then the value of Cell B20 in Sheet 2 would by "Yes" but it would be "No" if the valuein Cell A10 in Sheet 1 was less than 0.

I have created a formula in Excel that works fine, but when I put it into a MS Word table, it doesn't seem to work. The formula adds up a column of prices when the resulting column has a specific word in.

The formula is:

=SUMIF(E:E, "Yes", D:D)

Example:

Is this possible to do? If so can anyone help converting this so it will work in MS Word.

Thanks, Adam.

You'll have to do this:

https://support.office.com/en-us/art...4-0d7e88062257

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.

Hi,

I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.

Appreciate your help and thanks in advance !!!

It might be something to do with "<>cancelled"

Question:

If I am trying to add 3 cells and not all 3 cells always contain values. I have formulas in them and if the cell is empty then the #N/A comes up in the cell. So when I have the @sum in another cell to add them it doesn't compute.

Example:

A1 - 5

B1 - #N/A

C1 - 5

I want a formula to add these 3 cells up even when one of them is N/A ??????

You should use the IF statement to set the cells to do the function, or set it as a blank value if no numbers are present.

Post the formula you have in the cells that make them show NA.

History:

I have two excel sheets, 1) breaks 2) jobs for the day.

In the breaks sheet i have time listed down a5:a50 each cell represents 5 mins. within this sheet on b20:b:24 i have a 20min merged cells break.

On the second excel sheet i have the same time list from the

=now() in a1, showing the time down the page. Again i have sectioned each job in to time periods of merge cells. ie 10min = 2 merged cells, cleaning.

What i want to be able to do is create a formula that will look at the time from the sheet two, (jobs) copy that days jobs to the first sheet, Breaks, find the time and fill down, missing the breaks out and copy below the breaks for the period in time.

I know its a lot.

But if you can Help!!!!

Would defining rangenames help point to the areas on your second sheet (jobs), then developing a macro to do the math, copy, paste, etc?

I am doing a spreadsheet for a volunteer fire department and we want to be able to keep track of the percentage of meetings, drills, and fire calls each person attends. I thought I had it right but I guess not now. I've included what I have done so far.

My problem is I don't know how many members there is at the time so I just created enough for 47 members to be tracked (I'm sure it's less than that). I realize I have an error formula but after input is placed in cell it disapears. I do not want that error to show up if I haven't filled the cell (I don't want error printing out on sheet if there is no member listed for that row).

Also I would like someone to verify that I did things right at the bottom... Where I have Department Averages.

This is like my first spreadsheet I've done so be easy on me. Trial and error. Any suggestions would be appricated.

Thanks in advance,

Art

Filter the divisor with an IF function,

=IF(B6="","",C6/B6)

dear friends

is there any formula who prints the exect sheet name

eg.

in my excel workbook the 1st sheet name is "sample" so i want to use a formula who shows the sheet name as it is

Hi All,

I have a spreadsheet attached that lists revenue and target by month for each name. I need to make a ytd formula that can calculate this. I cannot move the columns of the data around, so they have to stay in this format. Can anyone help?

Thank you!

Winnie

=SUM(B2,D2,F2,H2,J2,L2,N2,P2,R2,T2,V2,X2)

and then copy across to cell aa

then select those two cells and copy down

or am i missing something else you need

Hi,

Does anyone know how to formulate the following:

X figure multiplied by .105, then that sum issubtracted from origianl X figure

Is this possible?

Thanks

Welcome to TSG!

=SUM(A1-(A1*0.105))

paste this function in cell B1 when the number you will input is in cell A1

You can then copy cell B1 and paste the function in B2-B??) and the values will change correspondingly to

=SUM(A2-(A2*0.105))

=SUM(A3-(A3*0.105))

etc

I'd like to create a formula (some kind of IF statement) to test a range of cells to determine if any hidden rows contain values. The statement could return a statement like "Alert - hidden values" if it returns true.

We have a billing sheet, and some of the users tend to hide rows that don't apply, forgetting to clear the values first. Then, the total does not appear to calculate correctly.

Any ideas? I know how to do the if statement, I just don't know how to test the range of cells in a formula. Thanks.

What I want to do is count columns that contain text entries, and do a running total,so if i have a 100 names or any text in the columns it will count them for me, if i add or delete an entry it will adjust the figures accordingly

Thanks

Rama

Hi there: What I am trying to do is set up an invoice. The invoice is complete and works well but I want to add a formula to calculate shipping and handling charges depending on the cost of the merchandise. There are 7 different levels for the charges depending on the cost. I have used nesting and it seems that I am only getting the first level charge no matter what the cost of the merchandise is. Are there any Excel experts out there who wouldn't mind giving me a hand? It would be greatly appreciated.

Thanks in heaps in advance.

Hello,

I was wondering if one of you Excel Gurus Could help me

I have tried some different formulas with the "if" command and what not but am Unable to do this. Basically when I copy a bunch of Asset tags into one Column (eg. G) I need to automatically filter the Desktops into another Column (eg. H). If any of the Numbers match the numbers in column G match any of the numbers in column A then have the filter remove the Numbers. Whatever is left put in Column H.

I know this is possible

I hope that is understandable

I have attached the Excel sheet in a zip file

Thanks in advance

Tim

I'm creating an attendance tracker for my employer. Row A is the date of occurrence (i.e. employee was late/absent), Row B is the value of the attendance issue (1 for being absent, 0.5 for being late/leaving early), Row C is running total, Row D is the date the value is to drop off (6 months after receiving). I'm trying to create a formula so that when today's date is equal to or after the drop date in Row D, the value in row B will automatically drop off in row C. Does anyone know how to do that?

Thanks!

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone

We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

An IF in column B may work

if C2 date is =or greater than date(Year(today()), Month(today())-6,day(today())

then , start sum again

I have a column with the following data examples in it:

8

HQ2394

HL3

H

CDHLQKN3428

HQ234

CDNQ3589

HLQKN342

HQKN342

HKLQ234

HQ28

HL

H8

D98

CDQKN3429

LQKN34289

3

3

3

3

DQKN3429L

KN34

LQKN34289

LKN348AU167RWX

L

L

L

L

L

AU16RWXKNO34

AU16RWXKNO34

What kind of formula can be written so that I can identify any cell with an L, or a 7 , or a 8 in it whether they are the only character in a cell or within a set of characters?

Hello,

I am struggling to find a formula that will do the following:

Sheet 1 lists all of the schools in my school district, with multiple columns. For example,

A2 = Central Elementary

B2 = # Tested Math

C2 = # Passed Math

D2 = % Passed Math

E2 = # Tested Reading

Etc.

Sheet 2 lists some of the schools with data for Math

A2 = Central Elementary

B2 = # Tested

etc

Sheet 3 lists some of the schools with data for Reading

I need a formula that will look for "Central Elementary" in Sheet 2 and then the corresponding data for that school. I can't do a simple copy and paste because not every school is listed in sheets 2 & 3, but all schools are listed on sheet 1.

So, my formula needs to look for Central Elementary in Sheet 2 and then the data from that sheet.

Hope this makes sense.

Thanks!

I attached a picture of the spreadsheet/current formula. I would like to add another formula into cell K101 so that when a value is entered into M101, K101 goes to 0.

I'm rustier than I thought with Excel, so here goes:

I'm creating a sales report spreadsheet. Cell C2 will be the invoiced amount. Cell Q2 is the sales rep's ID. Cell R2 is the commission (C2*.2) for the rep. Cell U2 is the company net (invoice minus commission). If there is a sales rep assigned to the client, how can a value in Q2 be worked into a formula so that if there is a rep their commission will show in R2 and the company's net in U2, but if there is no rep, there will be "zero" in R2 and the full invoice amount in U2? Must there be a number value in Q2, or will any data in Q2 work?

It should be an "IF-THEN" situation, but I'm obviously missing on the fine points of creating this formula.

I hope that I've made myself clear. Thanks.

Can someone tell me how to copy a formula into cells below without changing the formula to refer to the cells it is being copied to. For example. If I have a fromula in cell B2 that says B2*D2 and I want it to stay that way how can I prevent it from changing when it is copied into cells below. I want it to say B2*D2 all the way down. Thank you

=$B$2*$D$2

For instance, if you want to multiply all of the cells by a number in cell H1, you do this:

=A1*$H$1

Put the dollar sign in front of only the portion(s) you want to have *stuck*.

Need help with a GOTO formula... I am trying to do an IF statement that will then goto a particular cell. I.e. IF a1 = checking, then GOTO e1, IF a1=savings, then GOTO e5

If anyone could help with this it would be greatly appreciated.

Hi,

Can someone please tell me how this formula works:

{=SUM(($F$74:$F$123)*($M$74:$M$123>=G135)*($W$74:$W$123>=G135))/4*(1+Data!$AI$23)^(G135/4)}

All the data is numerical and the result that I get from the formula is simply ($F$74:$F$123)/4.

Thanks.

First, you should be getting a numerical result, so click in the cell, go to Format, Cell and select General. Other formats may work, but apply them later.

Next, the {} means this is an array formula (some people call them CSE formulas - you will see why soon). You don't type the {} in yourself - you type in the formula and hold down Control, Shift and hit Enter (hence CSE) and Excel adds the brackets automatically.

Next, you have several ranges, such as $F$74:$F$123. Just for clarity, I will point out that the range could be written as F74:F123 but that would be a relative range - if you copied the formula and pasted it elsewhere, Excel would alter the range to match. Having the $ in the formula makes these absolute values, so no matter where the formula is pasted, the range looked at is always this one (or, rather, these ranges.)

Your formula does several things, so let me break them up.

{=SUM(($F$74:$F$123)*($M$74:$M$123>=G135)*($W$74:$W$123>=G135))/4*(1+Data!$AI$23)^(G135/4)}

Any portion like

=SUM($F$74:$F$75)>=G135 (also an array formula)

looks at the sum in the range to see if it is greater or equal to the value in G135. (If it isn't (in any of the comparisons) you get a value of 0.)

The next batch is more of the same - just algebra.

Finally, (1+Data!$AI$23)^(G135/4) takes the value on the sheet called Data in cell A23, adds 1 to it and raises the whole thing to the value of whatever is in cell after dividing that value by 4 (e.g., if the value in Da... Read more

I hope you can help me with a fairly simple formula, but if formulas are really hard for me.

I want to put the work PAID in Cell b if Cell c has a date in it, otherwise I want it blank. Thanks in advance for your help.

Need help with a formula in excel.

I want to be able to calculate surface area, say of a box, by inputting the volume of the box.

I can do it on a calculator, but I don't think excel supports the cube root function.

can anyone help???

Welcome to TSG, Starfish

Cube rooting, although not directly supported, can be done using the POWER formula

=POWER(A1,1/3) (where A1 is the number to be cube rooted)

I am trying to find the formula to total up a sum between certain dates.

for example

In column A i have the dates

In column B i have the amounts paid in

I need to be able to click into a cell and use a formula to calculate the total amount in column B between certain dates in Column A.

EG: the amount paid in between 01/10/2007 and including 30/09/2008

i have tried the following but no sum comes out, =SUMIF(A:A,">01/10/2007and<30/09/2008",B:B)

Please Please can anyone help

Kaly

I am not a very experienced Excel persion but I believe the problem is that the "criteria" argument used in the SumIF function is unable to combine logical expressions like you are trying to do:

Can Do ">6/30/2007" and can do "<11/1/2007"

But Can't do ">6/30/2007 AND <11/1/2007" at the same time

For you particular problem there still is a solution that uses the SumIf function

Add up ALL of the payments and then, using SumIf, subtract off those that fall before the start date and those that fall after then ending date

So to add all the payments between (including) June 1 '07 and Sept 30 '07:

Good:

=sum(B1:Bn) - sumif(A1:An,"<6/1/2007",B1:Bn) - sumif (A1:An,">9/30/2007",B1:Bn)

Now if you think about this approach you see that it isn't really necessary to sum all the payments and subtract off both ends, you only need to sum all the payments that fall on or after the start date and then subtract off those that fall after the end date.

Better:

=sumif(A1:An,">5/31/2007",B1:Bn) - sumif (A1:An,">9/30/2007",B1Bn)

I currently have a formula that takes the current day, and compares to an Order Picked date.

The formula calculates is the difference between the dates is more than 2.5, "Overdue" is returned in the cell

The problem I encounter is on Mondays and Tuesdays, where I need to change the formula manually to 4.5 and 3.5

because the Sat and Sunday are not skipped and no orders are sent as those are off days. So an order picked on Friday

would show as Overdue on Monday as it is more than 2.5 days.

Original Formula : =IF((A2+2.5)<$C$3,"Overdue",IF((A2)>$C$3,"Future",""))

The new Formula: =IF(AND($D$3=”Monday”,A2+4.5<$C$3),”Overdue”, IF(AND($D$3=”Tuesday”,A2+3.5<$C$3),”Overdue”, IF((A2+2.5)<$C$3,"Overdue",IF((A2)>$C$3,"Future",""))))

has not worked. Perhaps wrongly positioned parenthesis? It returns #NAME#

A sample spreadsheet is attached.

I need help with an Excel Formula. I am creating a gradebook using points and not values for grades. For examples, E5:BE5 represents the total points possible for each assignment, E6:BE6 represents the actual points received, and E7:BE7 represents attendance. BD7 will sum E5:BE5, BC7 will sum E6:BE6, and BC6 will give the percent grade. My problem is when a new student comes in during the middle of marking period, I only want to add the total points from the point when he/ she entered. In other words, in E7:BE7 (attendance line) I want to put an "n" for new and in BD7 I wantto have a formula that states "if there is an "n" in E7:BE7 to sum only the cells of E5:BE5 that are after the column that "n" is in". Is this possible?

lbkubic said:

I need help with an Excel Formula. I am creating a gradebook using points and not values for grades. For examples, E5:BE5 represents the total points possible for each assignment, E6:BE6 represents the actual points received, and E7:BE7 represents attendance.Click to expand...

just to be sure what you're saying; Cell E5:BE5 contains the value of maximum points and the student score is in cell E6:BE6.

I am sure this is simply enough to do but I'm just not up to speed with excel, I am producing a simple series of spreadsheets for someone to use as a register of people attending class. So far I have 12 sheets, one per month, and on each I have the list of names and the dates they have attended. At the end of the spreadsheet I have a total for the month and also a year to date total.

What I want to know is how to I transfer the year to date total to the next spreadsheet so that by the end of the year they have the toatal for the year.

Many thanks in advance.

I have a spreadsheet which has results in columns.

Column A has the name of runners in the event, column B has where they finished (WON, 2nd, 3rd, etc). In column X I want to list the winner of the event for all runners except the winner.

Is there a formula that will do this for me.

The formula would need to be something like:

If column B =WON, then leave column X blank, if column B=(anything other than WON) find next record above where column B=WON and paste column A of that record into column X of this record.

I know that is not very well explained, but i have lots of records of races usually with 8 runners in each and against all that didnt win, I want to put the winners name in column X.

Please help!!!!!!!!!!!!!!

A question that have puzzeled me!

excel the total is 55,250.00 and its asking for me to turn this amount for the month of October to a formula equaling 10%.

Can anyone-someone answer this for soonnnnnnnnnnnnnnn.

I need some help with an If statement that has multiple conditions and uses VLOOKUP. Here is the current statement that works, but is only for 1 condition:

=IF(D6="Grand Total","",VLOOKUP(D6,Data!$1:$350,2,FALSE))

I need it to not only test D6 for "Grand Total", but also for "". So, it needs to go something like the below, which doesn't work:

=IF(D6="Grand Total" OR "","",VLOOKUP(D6,Data!$1:$350,2,FALSE))

Thanks in advance for taking the time to help.

=IF(OR(D6="Grand Total",D6=""),"",VLOOKUP(D6,Data!$1:$350,2,FALSE))

Try this

I need to enter this formula into excel:

=NETWORKINGDAYS(12-1-02, 11-1-22, July 4)

The start date is 12-1-02

The end date is 11-1-22

..and the vacation date is July 4th of every year.

How do I enter just July 4th so it does not count the year?

Looks like you can't:

http://www.uncc.edu/sysdev/HowTos/Excel/networkdays.htm

I am needing help with a formula

Formula is for cell d1

IF C1 IS BLANK

THEN LEAVE BLANK

IF C1 IS 0 OR GREATER THAN 0 THEN

B1-C1

Thanks for any help I can get.

Will C1 ever be less than zero? If not, this should work as the formula for d1.

=if(c1="","",b1-c1)

It looks at c1 and if c1 is blank, then return blank, otherwise return b1-c1.

Hope that helps.

I have a sheet that contains a list of numbers for each hour of each day, monday through sunday 1 to 24. I need a formula to calculate the average of those numbers for the full week and then I need to make a chart with those averages. Can anybody help?

How is your spreadsheet set out?

There is a simple average formula - but it all depends on the data it is looking at

Ok so I have my products in column B. In column H I have the price of each product. In column P, I want to be able to assign a value to each thing in column B and then add the total per month.

Product Month Price Total Product Sales by Month

Router JAN 899

Monitor JAN 219

Monitor JAN 219

Switch FEB 699

Etc.....Is there a formula for this?

All;

I'm working on a Excel template that was created by someone how left there is a formula that I'm haveing problmes identifying where the file is beening saved. Here is the formula: =IF(default_dir_admin="","",default_dir_admin) Basically I just what to allow users of the template to click on the save button and the file will save to the location in the default directory. Any help would be appreciated.

Hello there, welcome!

Some questions arise here. Is this an actual template file (.xlt)? If you only want the file saved to a specific directory, I suggest using an event trapping (before_save) to control it manually. This means some VBA.

Is that about what you were thinking?

I am running excel 2000 and I need a formula to do what I am fixing to put in if it is possible if it isn't please let me know.

if column c equals the word expense then add column D to Column E and total it below the last row on E if column C equals the word Income then add column D to Column F and total it in the following row of column F

if you can help me with this I would appreciate it ASAP thank you!

Will the attached file work for you? It is set to allow up to 30 entries but can easily extended by copying the formulas into additional rows.

Hi,

I want to be able to get excel to return a total based on adjacent cells with the returned formula being the lowest number in the other cells.

i.e. cell A1 will display the lowest number of cells A2 to A20 which will all have different numbers

Is this possible? If so can someone give me the formula

thanks in advance

Lee_1133

Hi,

I have a table of text values, case sensitive and I tried using COUNTIF() to count the number of occurrences of a particular pair of letters, like so:

BB:RR

BB:Rr

BB:rr

Bb:RR

Bb:Rr

etc....

I did COUNTIF(Range,"*BB*"), but I found it's not case sensitive, and it's counting BB and bb as well. Is there any way to make it case sensitive?

Rgds,

Tech Support Guy System Info Utility version 1.0.0.4

OS Version: Microsoft Windows 10 Home, 64 bit

Processor: AMD E-300 APU with Radeon(tm) HD Graphics, AMD64 Family 20 Model 2 Stepping 0

Processor Count: 2

RAM: 3682 Mb

Graphics Card: AMD Radeon HD 6310 Graphics, 384 Mb

Hard Drives: C: 273 GB (183 GB Free); D: 23 GB (2 GB Free);

Motherboard: Hewlett-Packard, 188B

Antivirus: Windows Defender, Disabled

Hey Folks, it has been about 20 years since I wrote formulas in excel and I just do not remember.

Wanting to set up a formula so that the sum of column G cells are always equal to 1000. I need to subtract the value of the corresponding cell in column E. For example if E45 equals 500 cell G45 needs to equal 1000. Greatly appreciate helping an OLD user.

not sure i understand

column g always = 1000

why sum

can you

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone

We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

Currently increasing a field (AJ2) based on certain criteria (If the designated cells (C5:C20 has and "X" in any of the column cells) (AJ2) would increase by (1) Now need to expand that criteria to include some additional entries as indicated at the bottom but exclude an entry of "N/C".

Current senerio;

AJ2 =SUMPRODUCT((MOD(COLUMN(C38:AZ38),2)=1)*C38:AZ38)

C38 =SUMPRODUCT((C3<>"")*(COUNTIF(C5:C20,"X")>0))

Need to expand the "X" in range C5:C20 to not be limited to just "X" but be expanded to include one of 10 specific text inputs like AWL, E/P, E/V or (7 other selected text inputs)

Thank you in advance

Winger

Winger, I cannot for the life of me work out ½ of what you're trying to do here. For instance, COLUMN(C38:AZ38) just gives you the column # for C:C, ie: 3.

This is a complete stab in the dark, but how about if you amended to something like

COUNTIF(C5:C20,{"X","Y","Z"})

?

HTH,

Andy

I need a spreadsheet formula that will reference an alternate numerical number in a sum function. I have a column of Priority values 1-22 and I want to assign a reverse value to each priority (i.e. 1=22, 2=21, 3=20, etc.) then I want to post the sum of the values incurred and not the sum of the numerical priority values in the cell at the bottom of the column. Should I be using LOOKUP in conjunction with SUM or SUMIF? Any ideas?