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
Bookmarks