re help

Autumn · Apr 25th, 2002, 11:46 AM

Thanks, the sumproduct formula worked. Can I carry it to multiple columns? If I have 5 columns of color and 5 columns of price?

Asala42 · Apr 25th, 2002, 11:54 AM

Hey again,

I was able to get it to work with more than 1 column- so it looks like more columns will be ok:

=SUMPRODUCT((A1:E100="red")*(F1:J16<50000))

Assuming Columns A,B,C,D,E colors match with columns F,G,H,I, and J respectively.

Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 11:46 AM	#1
Autumn New Member Join Date: Apr 2002 Posts: 8	Thanks, the sumproduct formula worked. Can I carry it to multiple columns? If I have 5 columns of color and 5 columns of price?

Apr 25th, 2002, 11:54 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Hey again, I was able to get it to work with more than 1 column- so it looks like more columns will be ok: =SUMPRODUCT((A1:E100="red")*(F1:J16<50000)) Assuming Columns A,B,C,D,E colors match with columns F,G,H,I, and J respectively. Adam