Posted to microsoft.public.excel.misc

Nickie[_2_] Nickie[_2_] is offline

external usenet poster

Posts: 2

SumProduct Formula Problem

I need a formular that will give me the total number of records that in
B2:B318 which equal "District" and I2:I318 for those records are not null,
this is what i have so far:
=SUMPRODUCT(('Hand Portable on Trains'!B2:B318="District")*('Hand Portable
on Trains'!I2:I318="<"))

Any help would be much appreciated

Kind regards

Nickie

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 problem	chedd via OfficeKB.com	Excel Worksheet Functions	2	November 27th 07 03:39 PM
Problem with SUMPRODUCT formula	Tasha	Excel Worksheet Functions	3	August 23rd 07 07:20 PM
Problem with SUMPRODUCT formula.	Andrew Mackenzie	Excel Discussion (Misc queries)	3	February 7th 07 01:24 PM
Problem with a SUMPRODUCT Formula	carl	Excel Worksheet Functions	8	March 20th 06 08:05 PM
Problem w/ A Sumproduct Formula	carl	Excel Worksheet Functions	2	March 17th 06 06:40 PM

All times are GMT +1. The time now is 10:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us