Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif and sumif for multiple conditions
i have a huge project i am working on and I will need to use countif and sum
if for a lot of the cells in the summary page 1. Do count if and sum if work the same way except one counts instances and one sums the cells? 2. if I use the formula helper, is the range the part that I want counted or added up? 3. If is use that helper and I need to have several conditions met for this to be added up or counted how do I input my conditions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif and sumif for multiple conditions
More detail and layout examples
-- Don Guillett Microsoft MVP Excel SalesAid Software "Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message ... i have a huge project i am working on and I will need to use countif and sum if for a lot of the cells in the summary page 1. Do count if and sum if work the same way except one counts instances and one sums the cells? 2. if I use the formula helper, is the range the part that I want counted or added up? 3. If is use that helper and I need to have several conditions met for this to be added up or counted how do I input my conditions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif and sumif for multiple conditions
If you want multiple conditions, the best way is usually to use SUMPRODUCT
(see many questions & answers in the archives of this group). If you don't understand the functioning or the syntax of the COUNTIF or SUMIF functions, look them up in Excel help. -- David Biddulph "Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message ... i have a huge project i am working on and I will need to use countif and sum if for a lot of the cells in the summary page 1. Do count if and sum if work the same way except one counts instances and one sums the cells? 2. if I use the formula helper, is the range the part that I want counted or added up? 3. If is use that helper and I need to have several conditions met for this to be added up or counted how do I input my conditions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif and sumif for multiple conditions
I have a summary tab and a data tab
I want to count all examples in K7:K9999 (Data Tab) when the following conditions are met: !DataAE7=!Summary$C$1 !DataK7=!Summary$A$10 I want to add up the total of $ in !DataQ7:Q9999 when the following conditions are met: !DataAE7=!Summary$C$1 !DataK7=!Summary$A$10 Once I have those I think I can run from there Thanks "Don Guillett" wrote: More detail and layout examples -- Don Guillett Microsoft MVP Excel SalesAid Software "Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message ... i have a huge project i am working on and I will need to use countif and sum if for a lot of the cells in the summary page 1. Do count if and sum if work the same way except one counts instances and one sums the cells? 2. if I use the formula helper, is the range the part that I want counted or added up? 3. If is use that helper and I need to have several conditions met for this to be added up or counted how do I input my conditions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumIF-multiple conditions/OR | New Users to Excel | |||
SUMIF with Multiple Conditions | Excel Worksheet Functions | |||
sumif with multiple conditions | Excel Worksheet Functions | |||
sumif with multiple conditions | Excel Worksheet Functions | |||
sumif - multiple conditions | Excel Worksheet Functions |