At 18:19 15/02/2017 -0500, Robert Peirce wrote:
I have data in a table by month. At the end of each year there is a
summary row separated by a blank line above and below. Frequently I
need to sum from, say, 03/16-02/17 so I have 10 rows with data I
want, three rows with data I don't want and
Hello,
Is there a way to identify the data you want? If so, you could use a
set of =SUMIF() or =SUMIFS() to add up the data that matches one or a
group of criteria. Otherwise, you may need to provide an example
(obviously scrubbed since it seems to be some financial data) because I
cannot quite
I have data in a table by month. At the end of each year there is a
summary row separated by a blank line above and below. Frequently I
need to sum from, say, 03/16-02/17 so I have 10 rows with data I want,
three rows with data I don't want and two more rows with data I want.
My approach has