Posted to microsoft.public.excel.worksheet.functions

SDH

external usenet poster

Posts: 19

SUMPRODUCT assistance

I am trying to count the number of occurences where Column F has a value =43
and the corresponding row in Column J has the word AGIMO.

I have the following but it doesn't seem to return a value. Am i on the
right track???

=SUMPRODUCT(('Gazettals 06-07'!F2:F1399=43),(J2:J1399="AGIMO"))

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 assistance - need multiple ANDs and ORs	Heidi	Excel Worksheet Functions	3	January 31st 07 05:09 PM
Sumproduct assistance	Barb Reinhardt	Excel Worksheet Functions	2	January 25th 07 04:52 PM
SUMPRODUCT Assistance	Barb Reinhardt	Excel Worksheet Functions	3	July 28th 06 08:54 PM
Assistance please?	http://	Excel Worksheet Functions	7	July 6th 05 08:16 PM
Need some assistance	N Schei	Charts and Charting in Excel	2	March 24th 05 07:58 PM

All times are GMT +1. The time now is 01:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us