Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Sumproduct with multiple criteria

I am trying to sum a monetary value with multiple criteria.

alumni, ages 41-55

I can't seem to figure out the formula.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 143
Default Sumproduct with multiple criteria

Say we have in A1 thru C17:
James Smith 32 $2,335
John Johnson 53 $788
Robert Williams 36 $4,020
Michael Jones 40 $730
William Brown 52 $3,500
David Davis 45 $4,995
Richard Miller 40 $1,389
Charles Wilson 57 $3,088
Joseph Moore 51 $4,663
Thomas Taylor 40 $2,482
Christopher Anderson 45 $2,454
Daniel Thomas 46 $2,691
Paul Jackson 59 $4,798
Mark White 51 $2,763
Donald Harris 39 $572
George Martin 37 $2,113
Kenneth Thompson 30 $3,268

then the formula:

=SUMPRODUCT((B1:B1740)*(B1:B17<56)*(C1:C17))
yields $21,854


Reply
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 that contains multiple criteria Sarah (OGI) Excel Worksheet Functions 3 September 2nd 09 02:35 PM
Multiple criteria for sumproduct ocuhcs Excel Discussion (Misc queries) 4 April 26th 09 02:44 AM
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria kazoo Excel Discussion (Misc queries) 2 August 21st 08 06:22 PM
SumProduct With Multiple criteria Tony D Excel Worksheet Functions 1 February 24th 06 10:26 PM
Using Sumproduct with multiple Criteria Mark Jackson Excel Worksheet Functions 1 May 6th 05 10:07 PM


All times are GMT +1. The time now is 03:26 PM.

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

About Us

"It's about Microsoft Excel"