Remember Me?

#1
November 2nd 04, 09:37 PM
 rajgopal Posts: n/a
How I use SUMIF & AND

How can I use SUMIF & AND to calculate the values? Here is the issue:

_Column_A___Column_B____Column_C_
east Type A 10
east Type B 15
west Type A 14
west Type B 6
north Type A 12

How can I sum "east" " type A"?

--
rajgopal
------------------------------------------------------------------------
rajgopal's Profile: http://www.excelforum.com/member.php...fo&userid=7281

#2
November 2nd 04, 09:52 PM
 Domenic Posts: n/a

=SUMPRODUCT(--(A1:A5="east"),--(B1:B5="type A"),C1:C5)

OR

=SUMPRODUCT(--(A1:A5=E1),--(B1:B5=F1),C1:C5)

Hope this helps!

--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785

#3
November 2nd 04, 09:52 PM
 Frank Kabel Posts: n/a

Hi
use SUMPRODUCT:
=SUMPRODUCT(--(A1:A100="east"),--(B1:B100="Type A"),C1:C100)

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"rajgopal" schrieb im
Newsbeitrag ...

How can I use SUMIF & AND to calculate the values? Here is the issue:

_Column_A___Column_B____Column_C_
east Type A 10
east Type B 15
west Type A 14
west Type B 6
north Type A 12

How can I sum "east" " type A"?

--
rajgopal
---------------------------------------------------------------------

---
rajgopal's Profile:

http://www.excelforum.com/member.php...fo&userid=7281

#4
November 2nd 04, 09:54 PM
 Paul B Posts: n/a

rajgopal, try something like this, this is an array formula enter with
(ctrl+shift+enter)

=SUM(IF((A2:A10="east")*(B2:B10="type A"),C2:C10))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

"rajgopal" wrote in message
...

How can I use SUMIF & AND to calculate the values? Here is the issue:

_Column_A___Column_B____Column_C_
east Type A 10
east Type B 15
west Type A 14
west Type B 6
north Type A 12

How can I sum "east" " type A"?

--
rajgopal
------------------------------------------------------------------------
rajgopal's Profile:
http://www.excelforum.com/member.php...fo&userid=7281

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Brent Martin Excel Discussion (Misc queries) 6 January 7th 05 06:17 AM Stan Excel Discussion (Misc queries) 5 December 16th 04 11:12 PM Frank Kabel Excel Discussion (Misc queries) 1 December 15th 04 10:56 PM Gita Mooney Excel Worksheet Functions 5 November 1st 04 05:18 PM Minitman Excel Worksheet Functions 3 November 1st 04 03:58 PM

All times are GMT +1. The time now is 02:25 PM.