Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > SumIf with 2 ctiteria
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 7
Default SumIf with 2 ctiteria
I need to sum the values in Column K if the values in Column D AND Column E
meet different criteria

e.g. Sum of values in Col K .... only if corresponding values Col D =
value_1 and Col E = value_2

Please post relevant vbacode

Thanks & TIA


Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 43
Default SumIf with 2 ctiteria

No relevant VBA-code is required since 2 criteria in a SUMIF can be done
with a so called CSE formula.
It's all he http://www.mrexcel.com/tip031.shtml




"Jimbo" schreef in bericht
...
I need to sum the values in Column K if the values in Column D AND Column E
meet different criteria

e.g. Sum of values in Col K .... only if corresponding values Col D =
value_1 and Col E = value_2

Please post relevant vbacode

Thanks & TIA



Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 7
Default SumIf with 2 ctiteria
Thank you for your response but I would like to use vba code to determine
the value

"moon" <6369706865725F6475646540706C616E65742E6E6C wrote in message
. ..

No relevant VBA-code is required since 2 criteria in a SUMIF can be done
with a so called CSE formula.
It's all he http://www.mrexcel.com/tip031.shtml




"Jimbo" schreef in bericht
...
I need to sum the values in Column K if the values in Column D AND Column
E meet different criteria

e.g. Sum of values in Col K .... only if corresponding values Col D =
value_1 and Col E = value_2

Please post relevant vbacode

Thanks & TIA





Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 10,593
Default SumIf with 2 ctiteria
myVal =
ActiveSheet.Evaluate("=SUMPRODUCT(--(D1:D1000=""value_1""),--(E1:E1000=""val
ue_2""))")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jimbo" wrote in message
...
I need to sum the values in Column K if the values in Column D AND Column
E
meet different criteria

e.g. Sum of values in Col K .... only if corresponding values Col D =
value_1 and Col E = value_2

Please post relevant vbacode

Thanks & TIA




Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 7
Default SumIf with 2 ctiteria
Thanks Bob,
I don't follow the syntax of the code you supplied ... where doe I specify
the values to be summated i.e. Column K
can you enlighten me or point me to a url for an explanation of the syntax
Regards
Jim Burton

"Bob Phillips" wrote in message
...
myVal =
ActiveSheet.Evaluate("=SUMPRODUCT(--(D1:D1000=""value_1""),--(E1:E1000=""val
ue_2""))")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jimbo" wrote in message
...
I need to sum the values in Column K if the values in Column D AND Column
E
meet different criteria

e.g. Sum of values in Col K .... only if corresponding values Col D =
value_1 and Col E = value_2

Please post relevant vbacode

Thanks & TIA






Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 10,593
Default SumIf with 2 ctiteria
myVal =
ActiveSheet.Evaluate("=SUMPRODUCT(--(D1:D1000=""value_1""),--(E1:E1000=""val
ue_2""),K1:K1000)")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jimbo" wrote in message
...
Thanks Bob,
I don't follow the syntax of the code you supplied ... where doe I specify
the values to be summated i.e. Column K
can you enlighten me or point me to a url for an explanation of the syntax
Regards
Jim Burton

"Bob Phillips" wrote in message
...
myVal =

ActiveSheet.Evaluate("=SUMPRODUCT(--(D1:D1000=""value_1""),--(E1:E1000=""val
ue_2""))")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jimbo" wrote in message
...
I need to sum the values in Column K if the values in Column D AND
Column
E
meet different criteria

e.g. Sum of values in Col K .... only if corresponding values Col D =
value_1 and Col E = value_2

Please post relevant vbacode

Thanks & TIA








Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 7
Default SumIf with 2 ctiteria
Many Many Thanks
Works exactly as I require

"Bob Phillips" wrote in message
...
myVal =
ActiveSheet.Evaluate("=SUMPRODUCT(--(D1:D1000=""value_1""),--(E1:E1000=""val
ue_2""),K1:K1000)")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jimbo" wrote in message
...
Thanks Bob,
I don't follow the syntax of the code you supplied ... where doe I
specify
the values to be summated i.e. Column K
can you enlighten me or point me to a url for an explanation of the
syntax
Regards
Jim Burton

"Bob Phillips" wrote in message
...
myVal =

ActiveSheet.Evaluate("=SUMPRODUCT(--(D1:D1000=""value_1""),--(E1:E1000=""val
ue_2""))")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jimbo" wrote in message
...
I need to sum the values in Column K if the values in Column D AND
Column
E
meet different criteria

e.g. Sum of values in Col K .... only if corresponding values Col D =
value_1 and Col E = value_2

Please post relevant vbacode

Thanks & TIA










Reply With QuoteReply With Quote
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 27,285
Default SumIf with 2 ctiteria
Just a thought,
If you lookup CSE in excel help, do you get a response.

It is non-standard terminology. It would be better to use the correct term
"array formula" so the OP actually learns something that can be communicated
in a discussion with other Excel users.

--
Regards,
Tom Ogilvy

"moon" <6369706865725F6475646540706C616E65742E6E6C wrote in message
. ..

No relevant VBA-code is required since 2 criteria in a SUMIF can be done
with a so called CSE formula.
It's all he http://www.mrexcel.com/tip031.shtml




"Jimbo" schreef in bericht
...
I need to sum the values in Column K if the values in Column D AND Column
E meet different criteria

e.g. Sum of values in Col K .... only if corresponding values Col D =
value_1 and Col E = value_2

Please post relevant vbacode

Thanks & TIA





Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear 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
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" Harry Seymour Excel Worksheet Functions 9 June 12th 07 10:47 PM
Embedding a Sumif in a sumif C.Pflugrath Excel Worksheet Functions 5 August 31st 05 07:31 PM
Sumif TYE Excel Worksheet Functions 0 August 31st 05 10:24 AM
nested sumif or sumif with two criteria dshigley Excel Worksheet Functions 5 April 5th 05 03:34 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM


All times are GMT +1. The time now is 10:24 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"

 

Contact Us ExcelBanter forum home Privacy Statement