Thread
:
Need help with sumif
View Single Post
#
2
Posted to microsoft.public.excel.misc
Biff
Posts: n/a
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
Reply With Quote