Countifs statement help

I'm having trouble with a formula here is what I am trying to do.

If cell A14 equals volkswagen and Cell I14 equals a date within the set date range then Cell J8 will count a whole number
If cell A14 equals volkswagen and Cell I14 equals a date within the set date range and Cell P14 has any text value entered then Cell J8 will count a half (0.5) number
Current formula in Cell J8 is below

Please Login or Register  to view this content.

Based on the image I have attached the following should be the value in cell J8 2.5

I have attached an example workbook to reference

1.PNG
Example_workbook.xlsx

Originally Posted by Ochimus

You're multiplying the two elements ("*"), not adding them.

Really? Try evaluating the formula, it adds them together, but multiplies the second one by 0.5, counting the result as half.

Your formula simply adds half to the total regardless of the original result.

Originally Posted by jason.b75

PNG images don't show up on the forum, JPEG images do, but workbooks are preferred.

Where is the set date range? You need 2 additional criteria for each countifs function, ($I$14:$I$178,">="&startdate,$I$14:$I$178,"<="&enddate)

edit:- Not seeing where you're getting 2.5 from though, unless the new formula should include all values in column K, even those with no text in column P.

There is a workbook attached and I have not had a problem in the past with .PNG showing up.

As for the counting

I have 3 values in the following cells
A12
A13
A14

I have 3 dates in Cells
I12
I13
I14

The cell P12 has text indicating that it is a split deal between myself and the other person
Cell P13 and P14 have no text indicating it will be a whole number and is not a split so thus for I have set a total of 2.5 appointments

I don't care how I get there or if there is a requirement within a date range I just need to numbers to add up properly.

Pretty much if Cell A12 = Volkswagen and Cell I12 has a date in it then cell J8 =1
If cell A13 = Volkswagen and Cell I13 has a date in it then cell J8 now =2

the total should now be 2

If cell A14 = Volkswagen and Cell I14 has a date in it and if Cell P14 has a text value in it then cell J8 =.5

the total in cell J8 should now be 2.5

The formula that I referenced above is the one in place right now that someone gave me and I just tested it and it is not doing what I wanted it to do.

The person posting a PNG image can see it because the original is on their computer, a few other people might be able to see it, if there browser is compatible, but the majority can't.

There are many ways to get the correct result, counting all rows with Volkswagen and a date, then subtracting half of the text count from column P is one of them.

=COUNTIFS($A$12:$A$176,I8,$I$12:$I$176,">0")-0.5*COUNTIFS($A$12:$A$176,I8,$I$12:$I$176,">0",$P$12:$P$176,"<>")

That is the exact formula that I was looking for. Thanks for the heads up on the .png I will start saving them in .jpeg