Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 270

Sumproduct Troubles

Sent this in ages ago but it never appeared in the group so here we go again
:-)

On Sheet2 I am trying to total the numbers on Sheet1 in the range
("C43:K43") only when "First" is the value in Range("C39:K39") and "Hit" is
the value in Range ("C40:K40"). I have tried the following to no avail:-

=SUMPRODUCT(--(Sheet1!C39:K39="First"),--(Sheet1!C40:K40="Hit"),--(Sheet1!C43:K43))

Any advice?
Sandy

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
SUMPRODUCT troubles	David	Excel Worksheet Functions	2	July 9th 07 09:04 PM
COM Add-in Troubles	Howard	Excel Discussion (Misc queries)	0	May 22nd 07 01:59 PM
Toolbar Troubles	brownti via OfficeKB.com	Excel Discussion (Misc queries)	2	May 3rd 07 10:02 PM
If, then statement troubles	beez	Excel Worksheet Functions	1	January 16th 07 11:31 PM
IF troubles	JG	Excel Worksheet Functions	6	December 24th 06 04:58 AM

All times are GMT +1. The time now is 09:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us