Countif - only 2 criteria match

[chimp]

i have now managed to get my countif statement to work thats to this
forum,

=COUNTIF(Sales!$F$6:$F$3041,C5)

my next step is to get this to work in tangent with another countif.

i need the above countiff to only work if the cell value in

=Sales!H9

is displaying the words "Quarter 1"

how would i adapt my count if to include this

 

[Peo Sjoblom]

=IF(Sales!H9="Quarter",COUNTIF(Sales!$F$6:$F$3041,C5),"")

 

[Don Guillett]

If I understand the problem, an if formula should do it.
=if(condition=true, then do this, "")
or
=if(sales!h9="Quater 1",COUNTIF(Sales!$F$6:$F$3041,C5),"")

 

[chimp]

right i am a little lost here, can someone please have a look for me...


on the Tab london

i am trying to autopopulate the fields in the colums labelled quarter
,2, 3, 4

i only want the count to occur if the sales sheet, make of car an
quater sold in match, i need to try and calculate how many of each ca
have been sold in each quater.

Please help

i am so lost

And

+----------------------------------------------------------------
| Attachment filename: test.zip
|Download attachment: http://www.excelforum.com/attachment.php?postid=358839
+----------------------------------------------------------------

 

[Don Guillett]

In cell i5
=SUMPRODUCT((Sales!$F$6:$F$26=TRIM($C5))*(Sales!$H$6:$H$26="Quarter 1"))
copy across the next 3 columns
change quarter in each to 1, 2,3,4
copy down