Hi Brad
okay with text values in B2:B5, and C2:C5 and E2:E5 and numeric values in
I2:I5 on a sheet called test
and with the criteria in I5, K5, O5 of the current sheet it worked for me.
are you sure that there are not things like trailing spaces in you ranges
which means that nothing matches the criteria?
if you've using ver 2002 / 2003 what does running the formula through tools
/ formula auditing / evaluate formula show?
Cheers
JulieD
"Brad_A" wrote in message
...
Julie,
I changed the formula to the following... as a test, I renamed the sheet
that it is checking and retrieving information from to Test.
=SUMPRODUCT(--(Test!B2:B5=I5),--(Test!C2:C5=K5),--(Test!E2:E5=O5),Test!I2:I5)
The result is a - in the cell. The Cell is R5 on the current sheet. Any
other suggestions?
"JulieD" wrote:
Hi Brad
haven't seen any of the previous converstation but the thing that strikes
me
about the formula is the order of the elements ...
=SUMPRODUCT(--(I5='Ferguson 06 Budget '!B2:B5000),--(K5='Ferguson 06
Budget
'!C2:C5000),--(O5='Ferguson 06 Budget '!E2:E5000),'Ferguson 06
Budget
'!I2:I5000)
are you sure you don't want
=SUMPRODUCT(--(06 Budget '!B2:B5000=I5),--('Ferguson 06 Budget
'!C2:C5000=K5),--('Ferguson 06 Budget '!E2:E5000=O5),'Ferguson 06
Budget
'!I2:I5000)
Cheers
JulieD
"Brad_A" wrote in message
...
Yes... that cell was referenced with a direct click on it. I still
haven't
figured out where my error is, and I have reviewed it as much as
possible.
"JE McGimpsey" wrote:
Check your worksheet name. Do you really have a space after Budget?
In article ,
Brad_A wrote:
I am using this formula... took out the period and year for now just
to
see
if I can get the formula to work.. It isn't working right now...
when I
press
enter, it opens up a thing to find a file. Also, it puts a - in the
cell. I
matched up all the categories also to get it to match.
=SUMPRODUCT(--(I5='Ferguson 06 Budget '!B2:B5000),--(K5='Ferguson 06
Budget
'!C2:C5000),--(O5='Ferguson 06 Budget '!E2:E5000),'Ferguson 06
Budget
'!I2:I5000)
What else should I do?
|