software

My spreadsheet looks like this
A B C D E
1 ABC Wireless 500 300 50
2 Hi-Tech 300 250 50
3 Top Wireless 400 250 50
4 ABC Wireless 250 250 50
5 Intel 700 250 50
6 Best Wireless 500 250 50

If A1:A6 ABC Wireless is found than add the B,C,D columns that's in same row
and sum it in E rowHi!

Try this:

=SUMPRODUCT((A1:A6=quot;abc wirelessquot;)*(B16))

Or

=SUMPRODUCT((A1:A6=A1)*(B16))

Biff

quot;Need help with sumifquot; lt;Need help with gt;
wrote in message ...
gt; My spreadsheet looks like this
gt; A B C D E
gt; 1 ABC Wireless 500 300 50
gt; 2 Hi-Tech 300 250 50
gt; 3 Top Wireless 400 250 50
gt; 4 ABC Wireless 250 250 50
gt; 5 Intel 700 250 50
gt; 6 Best Wireless 500 250 50
gt;
gt; If A1:A6 ABC Wireless is found than add the B,C,D columns that's in same
gt; row
gt; and sum it in E row
gt;
Not really a SUMIF problem - that's for matching ranges
Try =IF(A1=quot;ABC Wirelessquot;,SUM(B11),quot;quot;)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Need help with sumifquot; lt;Need help with gt;
wrote in message ...
gt; My spreadsheet looks like this
gt; A B C D E
gt; 1 ABC Wireless 500 300 50
gt; 2 Hi-Tech 300 250 50
gt; 3 Top Wireless 400 250 50
gt; 4 ABC Wireless 250 250 50
gt; 5 Intel 700 250 50
gt; 6 Best Wireless 500 250 50
gt;
gt; If A1:A6 ABC Wireless is found than add the B,C,D columns that's in same
gt; row
gt; and sum it in E row
gt;
This worked for me:

=SUMPRODUCT(--(A2:A7 = quot;ABC Wirelessquot;),(B2:B7) (C2:C7) (D27))
--
Kevin Vaughnquot;Need help with sumifquot; wrote:

gt; My spreadsheet looks like this
gt; A B C D E
gt; 1 ABC Wireless 500 300 50
gt; 2 Hi-Tech 300 250 50
gt; 3 Top Wireless 400 250 50
gt; 4 ABC Wireless 250 250 50
gt; 5 Intel 700 250 50
gt; 6 Best Wireless 500 250 50
gt;
gt; If A1:A6 ABC Wireless is found than add the B,C,D columns that's in same row
gt; and sum it in E row
gt;



quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; =SUMPRODUCT((A1:A6=quot;abc wirelessquot;)*(B16))
gt;
gt; Or
gt;
gt; =SUMPRODUCT((A1:A6=A1)*(B16))
gt;
gt; Biff
gt;
gt; quot;Need help with sumifquot; lt;Need help with gt;
gt; wrote in message ...
gt; gt; My spreadsheet looks like this
gt; gt; A B C D E
gt; gt; 1 ABC Wireless 500 300 50
gt; gt; 2 Hi-Tech 300 250 50
gt; gt; 3 Top Wireless 400 250 50
gt; gt; 4 ABC Wireless 250 250 50
gt; gt; 5 Intel 700 250 50
gt; gt; 6 Best Wireless 500 250 50
gt; gt;
gt; gt; If A1:A6 ABC Wireless is found than add the B,C,D columns that's in same
gt; gt; row
gt; gt; and sum it in E row
gt; gt;
gt;
gt; awesome it works great thanks !!!!!!!!
gt;