Posted to microsoft.public.excel.worksheet.functions

Nielly

external usenet poster

Posts: 3

Need help with sumproduct formula

I was given this formula =SUMPRODUCT(--(E2:E10="Dawn"),--(F2:F10="X"))
yesterday which worked perfectly. I tried to apply a "date" to one of
columns as a "name" but it does display the correct total.

I need to know how many times "8/11" in column B and "West" in column D are
in the same row.

Thank you in advance for your help.

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 Formula	Vanessa Simmonds	Excel Discussion (Misc queries)	4	April 2nd 09 01:25 AM
Nesting a sumproduct formula within a sumif formula.	jerrymcm	Excel Discussion (Misc queries)	2	October 3rd 07 03:35 PM
sumproduct formula	Todd	Excel Worksheet Functions	7	July 2nd 07 09:22 PM
Help - Looking for a Sumproduct formula	[email protected]	Excel Worksheet Functions	4	November 1st 06 07:39 AM
Sumproduct Formula	Mike	Excel Worksheet Functions	11	August 15th 05 02:13 AM

All times are GMT +1. The time now is 07:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us