Posted to microsoft.public.excel.worksheet.functions

Sam

external usenet poster

Posts: 699

Formula with multiple variables

I have two reports pulled into a workbook. I am trying to match three
columns of data and bring back the results from a 4th column. I am using the
following formula, but receive "0" in every field.

Any help?

=SUMPRODUCT(--('BO Data'!$E$2:$E$65533='SAP BW Data'!D2),--('BO
Data'!$F$2:$F$65533='SAP BW Data'!B2),--('BO Data'!$G$2:$G$65533='SAP BW
Data'!A2),('BO Data'!$D$2:$D$65533))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If,Then for multiple variables.	Eden397	Excel Discussion (Misc queries)	1	June 10th 08 09:46 PM
Multiple variables-SOS	Ang	Excel Worksheet Functions	3	April 27th 07 08:24 PM
look for a value with multiple variables	Andrea	Excel Discussion (Misc queries)	2	January 18th 07 12:24 PM
Formula for counting multiple variables in a spreadsheet	smorgan	Excel Worksheet Functions	6	February 25th 06 05:10 AM
if function multiple variables	cin	Excel Worksheet Functions	2	September 8th 05 09:32 PM

All times are GMT +1. The time now is 09:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us