Calculation from a certain point

E

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,540
Office Version
  1. 365
Platform
  1. Windows
Hi,

I am looking for a formula to add from a certain point in a list

I currently have a formula of

=SUMPRODUCT(--ISNUMBER(SEARCH(" Additions "," "&H14:H389&" ")),Q14:Q389)

Which will add anything in those ranges with "Additions" in the description

So what i am looking for is a calculation from this point to the end of the list

Hope this makes sense

Thanks

Forgot to mention H is the description and Q is the cost that needs totalling
 
Last edited:

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
ExcelRoy said:
Hi,

I am looking for a formula to add from a certain point in a list

I currently have a formula of

=SUMPRODUCT(--ISNUMBER(SEARCH(" Additions "," "&H14:H389&" ")),Q14:Q389)

Which will add anything in those ranges with "Additions" in the description

So what i am looking for is a calculation from this point to the end of the list

Hope this makes sense

Thanks
Click to expand...

What defines "this point"? do you have another column of dates or something?
 
Upvote 0
Hi,

Basically its a parts list, with prices

i have quantity, part number, description, price etc

each time the "additions" will be in a different line of the list

i need a total upto the word "additions" in column H and from "additions" in column H to the end of the list

Thanks
 
Upvote 0
ExcelRoy said:
Hi,

Basically its a parts list, with prices

i have quantity, part number, description, price etc

each time the "additions" will be in a different line of the list

i need a total upto the word "additions" in column H and from "additions" in column H to the end of the list

Thanks
Click to expand...

I'm maybe not understanding you, it would appear if you're totalling up to additions and from additions to the end of the list then thats everything in the list......no? can you display a sample please as I'm just not getting what you'r looking for from your descriptions
 
Upvote 0
Apologies

Yes you are correct

But, i need a break down of what was originally estimated and what it ended up costing

So for arguments sake we estimated 5 items at £50, but it actually took 8 items at £50 i can see that the additions were £150 and the original estimate was £250 totalling the job at £400

Basically a total at the bottom saying something like

Estimate Cost £250
Additions Cost £150

Total Job £400

Thanks
 
Upvote 0
ExcelRoy said:
Hi,

I am looking for a formula to add from a certain point in a list

I currently have a formula of

=SUMPRODUCT(--ISNUMBER(SEARCH(" Additions "," "&H14:H389&" ")),Q14:Q389)

Which will add anything in those ranges with "Additions" in the description

So what i am looking for is a calculation from this point to the end of the list

Hope this makes sense

Thanks

Forgot to mention H is the description and Q is the cost that needs totalling
Click to expand...
Does this...

=SUM(INDEX(Q14:Q389,MATCH("*Additions*",H14:H389,0)):Q389)

satisfy?

If not, would you post a scaled-down sample along with the desired result?
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Formula Calculation is Inadvertently Switching from Automatic to Manual...
Replies
0
Views
263
MNexcelguy19
M
M
  • Solved
Condition formatting - count how many of the same color OR value appears in the list ?
Replies
5
Views
178
Asbestos_Jen
Asbestos_Jen
B
  • Solved
Looking to expand tool to track vacation pro-rations
Replies
1
Views
307
bh24524
B
M
  • Solved
Dynamically Plot Data Points in Scatterplot
Replies
5
Views
668
felixstraube
F
J
  • Question Question
Excel chart with a line that will adjust certain cells
Replies
0
Views
301
jondavis1987
J

Forum statistics

Threads
1,224,602
Messages
6,179,844
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top