K
kitkat
-I'm a spreadsheet neat freak, so I like to keep my data in as few cell
as possible. Just a warning that I don't want to generate columns o
rows that won't have useful end-product info in them.-
I have a sheet of business transactions, and I'm really only concerne
with From, To, Type, and Cost. Only transactions of the "service" typ
matter to me, and I'm supposed to make a summary of each division'
transactions to itself.
I also don't like messing up the original formatting I was given--I wa
given the chart with autofilters on the top line. For any othe
filtering / conditions I have, I would rather put them into the cel
actually generating my result. (So far when I've looked up advance
filters, all I've found is help for generating new columns and rows.)
Just a few lines below the end of the functional cost column seemed
good place to put:
(by the way, if I have some formatting wrong, it's because I'
translating from the French and might forget to change a semicolon bac
toa comma, etc.)
=SUBTOTAL(9,Q2:Q12107)
That's nice because when I filter the From column (col. D), I ca
generate the total value of bills that division sent out. Similarly
just below that (for a lack of a better place to put it), I can coun
how many bills they sent out with =SUBTOTAL(2,Q2:Q12107) .
However...
When a reader is simply looking at a filtered-by-From-column view o
the spreadsheet, I'd like them to see those numbers as well as th
equivalent numbers for entries sent to and from the same division. I
it's unfiltered, it will show the value and number of "incestuous
transactions throughout, of course.
I don't need help showing certain lines; that can be done easily enoug
with the filter. I'm just looking to do conditional operations (lik
summing Q values from rows where D and F match) for a few summarizin
numbers.
(Oh, and as I said, I'm only looking at ones where Column H say
"service," though I don't think that needs to be built into th
commands. Col D is From; Col F is To.
as possible. Just a warning that I don't want to generate columns o
rows that won't have useful end-product info in them.-
I have a sheet of business transactions, and I'm really only concerne
with From, To, Type, and Cost. Only transactions of the "service" typ
matter to me, and I'm supposed to make a summary of each division'
transactions to itself.
I also don't like messing up the original formatting I was given--I wa
given the chart with autofilters on the top line. For any othe
filtering / conditions I have, I would rather put them into the cel
actually generating my result. (So far when I've looked up advance
filters, all I've found is help for generating new columns and rows.)
Just a few lines below the end of the functional cost column seemed
good place to put:
(by the way, if I have some formatting wrong, it's because I'
translating from the French and might forget to change a semicolon bac
toa comma, etc.)
=SUBTOTAL(9,Q2:Q12107)
That's nice because when I filter the From column (col. D), I ca
generate the total value of bills that division sent out. Similarly
just below that (for a lack of a better place to put it), I can coun
how many bills they sent out with =SUBTOTAL(2,Q2:Q12107) .
However...
When a reader is simply looking at a filtered-by-From-column view o
the spreadsheet, I'd like them to see those numbers as well as th
equivalent numbers for entries sent to and from the same division. I
it's unfiltered, it will show the value and number of "incestuous
transactions throughout, of course.
I don't need help showing certain lines; that can be done easily enoug
with the filter. I'm just looking to do conditional operations (lik
summing Q values from rows where D and F match) for a few summarizin
numbers.
(Oh, and as I said, I'm only looking at ones where Column H say
"service," though I don't think that needs to be built into th
commands. Col D is From; Col F is To.