Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
TimH
 
Posts: n/a
Default SUMIF based on 2 conditions

Is there a way to do SUMIF to sum a column of number based on meeting 2
independent conditions rather than 1. (i.e. checking independent values or
conditrions in 2 different cells.)
  #2   Report Post  
Paul Corrado
 
Posts: n/a
Default

=SUMPRODUCT(("rangea"="condition1)*("rangeb"="cond ition2")*("range to sum"))

Note all ranges must contain the same number of rows or columns.

With two columns of criteria and one column of data

=SUMPRODUCT(A1:A10="One")*(B1:B10=5)*(C1:C10))





"TimH" wrote in message
...
Is there a way to do SUMIF to sum a column of number based on meeting 2
independent conditions rather than 1. (i.e. checking independent values or
conditrions in 2 different cells.)



  #3   Report Post  
mzehr
 
Posts: n/a
Default

Hi Tim,
Yes

Sumproduct() Introduction For - Great explanations!!
see http://www.xldynamic.com/source/xld.SUMPRODUCT.html


"TimH" wrote:

Is there a way to do SUMIF to sum a column of number based on meeting 2
independent conditions rather than 1. (i.e. checking independent values or
conditrions in 2 different cells.)

  #4   Report Post  
RagDyer
 
Posts: n/a
Default

To answer your original question, yes, there is a *way*.
And that "way" is to *add* the SUMIF()'s.

=SUMIF(A1:A100,D1)+SUMIF(A1:A100,D2)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"TimH" wrote in message
...
Is there a way to do SUMIF to sum a column of number based on meeting 2
independent conditions rather than 1. (i.e. checking independent values or
conditrions in 2 different cells.)

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
SUMIF with two conditions ? Mestrella31 Excel Discussion (Misc queries) 9 December 22nd 04 01:09 AM
Sum(if ... multiple conditions ... Interpretation? Ken Excel Discussion (Misc queries) 6 December 16th 04 11:23 PM
SUMIF with only one criteria cell within range Stan Excel Discussion (Misc queries) 5 December 16th 04 11:12 PM
formula based on format James Kendall Excel Discussion (Misc queries) 4 December 16th 04 05:47 PM
counting based on 2 conditions Thrava Excel Discussion (Misc queries) 3 December 8th 04 11:19 PM


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

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"