Adding two different COUNTIF formulas

0
votes

How can I add two different COUNTIF formulas that look at different criteria. For example:

Column A shows me dates 4/1/2013
Column B shows me the Type of product HQTT

I plug this formula in: 

=COUNTIF(A:A,M3)+COUNTIF(B:B,"HQ TT")

However this gives me 2 when it should be 1 because I only have one row that says 4/1/2013 with the product HQTT.

2
countif
1 [countif] tag is a bit vague - is this in Excel? - PeteGO
Can you provide the spreadsheet? - PeteGO
Um How do I add the spreadsheet? - Sarahi Andrade
@PeteGO? I am not sure how to add the spreadsheet on here? I feel weird asking lol - Sarahi Andrade

2 Answers

0
votes

Your formula is saying:

Count all the '4/1/2013' values in column A.

Count all the 'HQ TT' values in column B.

Give me the sum of these 2 counts.

I think what you want is a 3rd column, =A&B and a formula on that =COUNTIF(C:C,M3&"HQ TT")

0
votes

For the sake of an answer, per OP:

I used this formula
=COUNTIFS(A:A,Q37,B:B,"HQ TT")
and Im getting the results I need.