Help with adding certain cells using an IF function

J

Jrr6415sun

Is there a way in excel to go through each row and add a certain cell if
it meets a certain condition in an adjacent cell?

for example

Item Quantity Price

Pin 5 20
Tag 8 40
Pin 3 15
Tag 2 10
Tag 1 7

I want to add up all the prices if the item is a pin
 
R

RagDyeR

Try this:

=SUMIF(A:A,"Pin",C:C)

OR

Enter the item to lookup in another cell (D1), for easy revision:

=SUMIF(A:A,D1,C:C)

--

HTH,

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


in message
Is there a way in excel to go through each row and add a certain cell if
it meets a certain condition in an adjacent cell?

for example

Item Quantity Price

Pin 5 20
Tag 8 40
Pin 3 15
Tag 2 10
Tag 1 7

I want to add up all the prices if the item is a pin
 
J

Jrr6415sun

thank you very much

what if i want 2 criteria like in one column it has to be a pin and in
the other column it has to be the right date. Is there a way to do
this?
 
R

RagDyer

Enter the item in D1, and the date to match in D2, with the date containing
column as B:

=SUMPRODUCT((A1:A100=D1)*(B1:B100=D2)*C1:C100)

With this formula, you can't use total column references (A:A, B:B ...etc.).

--
HTH,

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

Padgett

The formulas given do work but you have a second option...

Choose...Tools, Addins and turn on your conditional sum wizard...Then
from the Tools menu choose 'conditional sum' and add whatever
conditions you want to the grid as shown in the graphic i
uploaded...last steps just ask you where you want your answer/s to
land...choose however many cells you need to catch the final result.
Luck to you
NMP


+-------------------------------------------------------------------+
|Filename: CSumWizard Example.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3586 |
+-------------------------------------------------------------------+
 
Top