Thread: Array Formula COUNTIF & SUM not working

Hi guys, im having a problem that when i made a table for lease, used and new cars and next to them is amounts of the specific criteria.... the problem is

for Lease count i applied =COUNTIF(I3:I102,"Lease Buy")
for Lease amount sum i applied =SUM((I3:I102="Lease Buy")*(T3:T102))

for Used count i applied =COUNTIF(I3:I102,"Used")
for Used amount sum i applied =SUM((I3:I102="Used")*(T3:T102))

The above all are working but!!!!!!!!

for New count i applied =COUNTIF(I3:I102,"New")
its showing zero in result =SUM((I3:I102="New")*(T3:T102))

Why its not working please help...
btw the i coulmn is filled till i49 and the rest of it are blank but in used case it shows the correct answer but when connected "NEW" it shows a zero instead of counted n sum result....

THanks

Originally Posted by DonkeyOte

Is suspect the values aren't "New" but include leading/trailing spaces... either correct originals or use wildcards (if viable), eg:

=COUNTIF(I3:I102,"*New*")

For your SUM you should use SUMIF rather than an Array

=SUMIF(I3:I102,"Lease Buy",T3:T102)

etc

(same point holds true for the SUMIF as the COUNTIF re: New)

Man youre genius youre simply awesomeeeeeeeeeeeeeeeee................
thanks a tons.... its solved