Need help with sumif
 

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 row

Need help with sumif
 

Hi!

Try this:

=SUMPRODUCT((A1:A6="abc wireless")*(B1:D6))

Or

=SUMPRODUCT((A1:A6=A1)*(B1:D6))

Biff

"Need help with sumif" <Need help with
wrote in message ...
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 row

Need help with sumif
 

Not really a SUMIF problem - that's for matching ranges
Try =IF(A1="ABC Wireless",SUM(B1:D1),"")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Need help with sumif" <Need help with
wrote in message ...
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 row

Need help with sumif
 

This worked for me:

=SUMPRODUCT(--(A2:A7 = "ABC Wireless"),(B2:B7)+(C2:C7)+(D2:D7))
--
Kevin Vaughn


"Need help with sumif" wrote:

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 row

Need help with sumif
 

"Biff" wrote:

Hi!

Try this:

=SUMPRODUCT((A1:A6="abc wireless")*(B1:D6))

Or

=SUMPRODUCT((A1:A6=A1)*(B1:D6))

Biff

"Need help with sumif" <Need help with
wrote in message ...
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 row


awesome it works great thanks !!!!!!!!