| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula that sums the values if you have 2 criteria and 2 differe.
I need a formula that sums the values with 2 different criteria and 2
different look up ranges |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
=sumif(...) +sumif(...)
Using this: http://www.officearticles.com/excel/...ft_excel.h tm ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
=sumproduct(--(rng1=value1),--(rng2=value2),rng1)
will sum the values in rng1 where the two criteria match -- HTH RP (remove nothere from the email address if mailing direct) "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
Some day, I'm going to make you or Zack teach me those dashy things, Bob.
************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... =sumproduct(--(rng1=value1),--(rng2=value2),rng1) will sum the values in rng1 where the two criteria match -- HTH RP (remove nothere from the email address if mailing direct) "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
Anne,
It's already written it up. See http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards Bob "Anne Troy" wrote in message ... Some day, I'm going to make you or Zack teach me those dashy things, Bob. ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... =sumproduct(--(rng1=value1),--(rng2=value2),rng1) will sum the values in rng1 where the two criteria match -- HTH RP (remove nothere from the email address if mailing direct) "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
OMG. I don't want to learn all that. :)
But I'll link to your site, for sure! ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... Anne, It's already written it up. See http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards Bob "Anne Troy" wrote in message ... Some day, I'm going to make you or Zack teach me those dashy things, Bob. ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... =sumproduct(--(rng1=value1),--(rng2=value2),rng1) will sum the values in rng1 where the two criteria match -- HTH RP (remove nothere from the email address if mailing direct) "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
"Anne Troy" wrote in message ... OMG. I don't want to learn all that. :) You can never learn too much, :-)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula that only adds numbers that meet specific criteria | Excel Discussion (Misc queries) | |||
| Data Validation - Scroll in the formula bar for a custom criteria | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| formula that meets two criteria and sums? | Excel Discussion (Misc queries) | |||
| Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
Hybrid Mode
