Sum only specific cells based on value in adjacent cell
 

I want to have a cell that is calculating all costs in a particular category.
The data is laid out in rows, so I will have the following columns:

Date Vendor Category Amount

I want a cell that is adding all amounts that are listed as a particular
category. One category might be "Events", another "Operations", etc. I want
these totals to be separated per category.
--
KKD

Sum only specific cells based on value in adjacent cell
 

With category in C and Amount in D use SUMIF

=SUMIF(C:C,"Events",D:D)

If this post helps click Yes
---------------
Jacob Skaria


"KKD" wrote:

I want to have a cell that is calculating all costs in a particular category.
The data is laid out in rows, so I will have the following columns:

Date Vendor Category Amount

I want a cell that is adding all amounts that are listed as a particular
category. One category might be "Events", another "Operations", etc. I want
these totals to be separated per category.
--
KKD

Sum only specific cells based on value in adjacent cell
 

Subtotal at change in each Category?

KKD wrote:
I want to have a cell that is calculating all costs in a particular category.
The data is laid out in rows, so I will have the following columns:

Date Vendor Category Amount

I want a cell that is adding all amounts that are listed as a particular
category. One category might be "Events", another "Operations", etc. I want
these totals to be separated per category.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1

Sum only specific cells based on value in adjacent cell
 

Can I add an additional criteria to this formula? For instance, can I say sum
if category is Events and date is 1/1/09?
--
KKD


"Jacob Skaria" wrote:

With category in C and Amount in D use SUMIF

=SUMIF(C:C,"Events",D:D)

If this post helps click Yes
---------------
Jacob Skaria


"KKD" wrote:

I want to have a cell that is calculating all costs in a particular category.
The data is laid out in rows, so I will have the following columns:

Date Vendor Category Amount

I want a cell that is adding all amounts that are listed as a particular
category. One category might be "Events", another "Operations", etc. I want
these totals to be separated per category.
--
KKD

Sum only specific cells based on value in adjacent cell
 

It's best to assign specific cells to contain your variable criteria, so
that you don't have to change the formula itself when the criteria changes.

With say desired date entered in E1, and desired category entered in F1,
try this:

=Sumproduct((A2:A25=E1)*(C2:c25=F1)*D2:D25)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"KKD" wrote in message
...
Can I add an additional criteria to this formula? For instance, can I say
sum
if category is Events and date is 1/1/09?
--
KKD


"Jacob Skaria" wrote:

With category in C and Amount in D use SUMIF

=SUMIF(C:C,"Events",D:D)

If this post helps click Yes
---------------
Jacob Skaria


"KKD" wrote:

I want to have a cell that is calculating all costs in a particular
category.
The data is laid out in rows, so I will have the following columns:

Date Vendor Category Amount

I want a cell that is adding all amounts that are listed as a particular
category. One category might be "Events", another "Operations", etc. I
want
these totals to be separated per category.
--
KKD