Posted to microsoft.public.excel.misc

ISAF Media Analysis[_2_] ISAF Media Analysis[_2_] is offline

external usenet poster

Posts: 21

SUMPRODUCT issue

Hello,

I'm trying to measure across three diferent columns, however the formula I
am using does not work. I have place the formula below. Can anyone help?
Thanks in advance.

=SUMPRODUCT(--(A2:A200="AIP"),--(F2:F200="IED")),--(H2:H200="P")))

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 Issue	Stuck	Excel Worksheet Functions	5	July 16th 09 01:18 AM
Sumproduct Issue	Jeff Gross	Excel Worksheet Functions	5	September 9th 08 06:49 PM
I believe this is a SUMPRODUCT issue	WLMPilot	Excel Worksheet Functions	2	August 14th 08 09:35 PM
Issue with sumproduct	Steved	Excel Worksheet Functions	8	July 18th 05 11:19 PM
SUMPRODUCT issue	TonyL	Excel Worksheet Functions	2	May 27th 05 12:46 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us