| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Oops! Add total of visitors H25:G60
Thanks, -- Lost at Work "Bob Phillips" wrote: Add what? Or count? =SUMPRODUCT(--(B25:B60="Sports"),--(C25:C60="New"),--(G25:G60=--"2004-01-11" )) -- HTH Bob Phillips "lost at work" <lost at wrote in message ... Need help! I need to have the following put into a function: If B25:B60 = "Sports" and C25:C60 = "New" and G25:G60 = "11/1/2004" then add only those that meet all three criteria. Thanks to the great brain that helps. |
|
#2
|
|||
|
|||
|
I assume that you mean H25:H60
=SUMPRODUCT(--(B25:B60="Sports"),--(C25:C60="New"),--(G25:G60=--"2004-01-11" ),H25:G60) -- HTH Bob Phillips "Lost at Work" wrote in message ... Oops! Add total of visitors H25:G60 Thanks, -- Lost at Work "Bob Phillips" wrote: Add what? Or count? =SUMPRODUCT(--(B25:B60="Sports"),--(C25:C60="New"),--(G25:G60=--"2004-01-11" )) -- HTH Bob Phillips "lost at work" <lost at wrote in message ... Need help! I need to have the following put into a function: If B25:B60 = "Sports" and C25:C60 = "New" and G25:G60 = "11/1/2004" then add only those that meet all three criteria. Thanks to the great brain that helps. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| How do I do multi VLOOKUP's based on certain criteria per cell? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Hybrid Mode
