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?