subtotal with sumif

P

pugazh

New Member
Joined
Feb 21, 2010
Messages
11
http://chandoo.org/forum/threads/subtotal-with-sumif.36629/
In the attached sample file.
Sum value of qty of machines required to come sheet "Costing"from cell range E5:E244 against each machine type given in sheet "Investment" in corresponding year 2019 to 2024.
Value should get automatically change according to filters applied in sheet "Costing".

What is the correct excel formula to be used?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You must log in or register to reply here.

Similar threads

A
  • Solved
Conditional Formatting for rows of empty cells corresponding with dates between
Replies
4
Views
520
avril18
A
A
  • Question Question
Lookup Help! Data table is dynamically dependent on data present in a row against which lookup is needed.
Replies
1
Views
591
asadriaz
A
M
  • Question Question
Book Cost Query
Replies
1
Views
765
M10Ant
M
R
  • Question Question
Generate dynamic templates with varying mandatory and non-mandatory fields depending on the product type chosen.
Replies
1
Views
1K
RajK2005
R
W
  • Question Question
Dynamic XIRR for sum of CF's with Offset
Replies
3
Views
4K
DRSteele
DRSteele

Forum statistics

Threads
1,224,825
Messages
6,181,190
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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