software

i have a spreadsheet im working on, but i want it to do somthing i dont
know if it can do. here is my problem

A B C H
1 A1 B1 C1 H1
2 A2 B2 C2
3 A3 B3 C3
4 A4 B4 C4
5 A5 B5 C5so i want H1 to = a range 0f data. i want it to look in column A for
certain criteria, and if that row in column A meets the criteria it
takes that same rows column C value and adds them together. so if it
were to be a logical test it would be somthing like this

if A1:A5= A2,A4,A5. then take the sum of C2,C4,C5. and put it in H1

let me know if you guys understand what im looking for.

Thanks--
mark petrak
------------------------------------------------------------------------
mark petrak's Profile: www.excelforum.com/member.php...oamp;userid=26804
View this thread: www.excelforum.com/showthread...hreadid=512366Let's say that the quot;certain criteriaquot; is in D1,

Then try this:

=SUMIF(A1:A5,D1,C1:C5)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;mark petrakquot; gt;
wrote in message
...
gt;
gt; i have a spreadsheet im working on, but i want it to do somthing i dont
gt; know if it can do. here is my problem
gt;
gt; A B C H
gt; 1 A1 B1 C1 H1
gt; 2 A2 B2 C2
gt; 3 A3 B3 C3
gt; 4 A4 B4 C4
gt; 5 A5 B5 C5
gt;
gt;
gt; so i want H1 to = a range 0f data. i want it to look in column A for
gt; certain criteria, and if that row in column A meets the criteria it
gt; takes that same rows column C value and adds them together. so if it
gt; were to be a logical test it would be somthing like this
gt;
gt; if A1:A5= A2,A4,A5. then take the sum of C2,C4,C5. and put it in H1
gt;
gt; let me know if you guys understand what im looking for.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; mark petrak
gt; ------------------------------------------------------------------------
gt; mark petrak's Profile:
www.excelforum.com/member.php...oamp;userid=26804
gt; View this thread: www.excelforum.com/showthread...hreadid=512366
gt;=sumif(a1:a5,a1,c1:c5)
mark petrak wrote:
gt;
gt; i have a spreadsheet im working on, but i want it to do somthing i dont
gt; know if it can do. here is my problem
gt;
gt; A B C H
gt; 1 A1 B1 C1 H1
gt; 2 A2 B2 C2
gt; 3 A3 B3 C3
gt; 4 A4 B4 C4
gt; 5 A5 B5 C5
gt;
gt; so i want H1 to = a range 0f data. i want it to look in column A for
gt; certain criteria, and if that row in column A meets the criteria it
gt; takes that same rows column C value and adds them together. so if it
gt; were to be a logical test it would be somthing like this
gt;
gt; if A1:A5= A2,A4,A5. then take the sum of C2,C4,C5. and put it in H1
gt;
gt; let me know if you guys understand what im looking for.
gt;
gt; Thanks
gt;
gt; --
gt; mark petrak
gt; ------------------------------------------------------------------------
gt; mark petrak's Profile: www.excelforum.com/member.php...oamp;userid=26804
gt; View this thread: www.excelforum.com/showthread...hreadid=512366

--

Dave Peterson


i dont think thats is what i need, say cell A1 says X and Cell A2 says Y
and Cell3 says Z i want Cell H1 to look at the cells for the criteria of
either X and Z and list the Total of the corrisponding Column

A B H
1 X 1 =4 or b1 b3
2 Y 2
3 Z 3--
mark petrak
------------------------------------------------------------------------
mark petrak's Profile: www.excelforum.com/member.php...oamp;userid=26804
View this thread: www.excelforum.com/showthread...hreadid=512366Then try this:

=SUM(SUMIF(A1:A5,{quot;xquot;,quot;zquot;},C1:C5))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;mark petrakquot; gt;
wrote in message
...
gt;
gt; i dont think thats is what i need, say cell A1 says X and Cell A2 says Y
gt; and Cell3 says Z i want Cell H1 to look at the cells for the criteria of
gt; either X and Z and list the Total of the corrisponding Column
gt;
gt; A B H
gt; 1 X 1 =4 or b1 b3
gt; 2 Y 2
gt; 3 Z 3
gt;
gt;
gt; --
gt; mark petrak
gt; ------------------------------------------------------------------------
gt; mark petrak's Profile:
www.excelforum.com/member.php...oamp;userid=26804
gt; View this thread: www.excelforum.com/showthread...hreadid=512366
gt;
Thanks That Is Perfect!!!!! Yay--
mark petrak
------------------------------------------------------------------------
mark petrak's Profile: www.excelforum.com/member.php...oamp;userid=26804
View this thread: www.excelforum.com/showthread...hreadid=512366