Multiple Conditions

[Lordbean]

Hi,
Trying to find formula to attached. "Raw" data displays date of sale
item number sold and value of sale. Report is headed up dates (columns
x Item numbers (rows) Formula needs to report sales value of each ite
within the user defined date ranges. Conditions are that Item number i
equal to item number in row and sale was made on column date or prio
to next column date. If so; sum value of sales for each item withi
defined date range. Trying to avoid sumif's on sumif's or looked u
values..... burns out CPU!!

Many thanks

bean

Attachment filename: formula testing.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52059

 

[Frank Kabel]

Hi
without looking at your attachment (you may try to explain
your exact issue without an attachment: post example data
as plain text) Two possible alternatives:
1. Using SUMPRODUCT to sum the values based on condition.
something like
=SUMPRODUCT(--(date_range>=date_value1),--
(date_range<=date_value2),--
(item_range=item_id),value_range)

No chance IMHO if you want to use formulas to avoid
SUMIF/SUMPRODUCT. And depending on your ranges this could
slow down the spreadsheet

2. You may consider using a pivot table for this

 

[Lordbean]

Many thanks Frank - That pretty well worked.

bean