LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDB JDB is offline
external usenet poster
 
Posts: 42
Default Sumproduct with conditions

Hi,

Many thanks to all those who've helped me out previously!

My latest problem is that I have a large worksheet of data. I need to find
out how many times an operators number has appeared in column (Column F) and
what the results were of a particular measurement (Column M). I'm
constructing a balanced scorecard that reads from various other workbooks and
have got those to work, however this is the only book where the data is
ranged differently. The operator numbers do not appear sequentially, just as
and when they happen to have been measured.

Any help, as always, greatly appreciated!

Jason
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Multiple < Conditions undrline via OfficeKB.com Excel Worksheet Functions 4 March 15th 07 06:04 PM
SUMPRODUCT with conditions sahafi Excel Worksheet Functions 3 November 30th 06 10:32 PM
Conditions in sumproduct Antonio Excel Worksheet Functions 3 October 26th 06 03:18 AM
sumproduct three conditions Scire Excel Worksheet Functions 3 May 9th 06 06:22 PM
Sumproduct Multiple Conditions Tysone Excel Worksheet Functions 3 November 10th 04 03:03 PM


All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"