View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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?