Conditional Subtotal in table

E

Esh

I have a spreadsheet with several different years of data in one row (last
year, this year, original plan).

I can create a table to subtotal by different criteria, but I'd like to add
a subtotal based on the text in another row.

Example: Sales at Cost are in column E. The year (TY, LY) is in column D.

Is it possible to subtotal only visible cells in column E when column D="TY"?
 
M

Marcelo

if you are looking for one conditional use

=sumif(d2:d100,"TY",f2:f100)
assuming your figures are in column F

if you are looking for a multiple conditionals use

=sumproduct(--(e2:e100="Sales at Cost")*(d2:d100="TY");(f2:f100))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Esh" escreveu:
 
E

Esh

Thanks for the reply! The SUMIF does what I need it to do, but I need it to
only SUM visible cells, since the way I get the data, LY/TY are in the same
row.
 
M

Marcelo

a pivot table could help you?


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Esh" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Text data using the Data - Subtotal feature 1
subtotal formatting 0
subtotal titles 1
Display Multiple Cells when Using Subtotal Function 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
subtotal filter with growing range 2
Pivot Table Values as a % of a Subtotal 1
% of subtotal in pivot table 1

Top