are you using the =SUBTOTAL function because some of your rows become filtered out ?
I was after a similar function that subtotalled (on filtered rows) but with conditions a little while ago.
Guess what ? I failed.
in the end, I stuck my criteria in columns over to thr right
ie : if a1="dog" then put in the value
next column if a1="cat" then put in the value
etc etc etc
then, underneath these columns (which are your criteria) you apply the same =subtotal function as your original ranges.... it effectively subtotals each column which is in itself based on a *single* criteria
if you have 2 or more, just use an =AND function
not much help eh ?
Chris
edit.......
if your subtotals are just =SUMS try a search in this board on "SUMPRODUCT" and "Aladin" he has some great sumproduct formulae that sum and count based on single or multiple criteria.... This message was edited by Chris Davison on 2002-03-27 15:13
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.