excel - How do I use IF formulas to display blanks or 0's dependent on data in other columns?

Question

I am trying to get rows within column G in sheet STATISTICS to populate a 0 if there is no L's to count in column P on sheet TRADE LOG.

However, if there are any L's present in column P in sheet TRADE LOG then I would like these counted and a value displayed in the rows of column G on sheet STATISTICS.

The issue is that despite COUNTIF naturally producing a 0I do not want a 0 present if there is NO data in the rows of column E on sheet STATISTICS

My current formula is as below:

=COUNTIFS('TRADE LOG'!P:P,"L",'TRADE LOG'!B:B,">="&DATE(2021,2,1),'TRADE LOG'!B:B,"<="&DATE(2021,2,28))

This is also all to be done within a date range as seen in the formula.

Could anyone suggest how I can achieve this? (VBA suggestions welcomed by if can be avoided then great)

question from:https://stackoverflow.com/questions/66050607/how-do-i-use-if-formulas-to-display-blanks-or-0s-dependent-on-data-in-other-col

Answer 1

Give this a try:

=if(COUNTIFS('TRADE LOG'!P:P,"L",'TRADE LOG'!B:B,">="&DATE(2021,2,1),'TRADE LOG'!B:B,"<="&DATE(2021,2,28))=0,"",COUNTIFS('TRADE LOG'!P:P,"L",'TRADE LOG'!B:B,">="&DATE(2021,2,1),'TRADE LOG'!B:B,"<="&DATE(2021,2,28)))