Forum Discussion

Ding080's avatar
Ding080
Copper Contributor
Jun 18, 2022

how to integrate "isblank" with other formulas

Hi all, I'm not sure where to insert a "isblank command in my formula, what are the rules with doing this?

I want to do a duplicate count and transfer the data to a pie chart without the blank cells being included in the chart. 

Here is my formula:

=COUNTIF('MY TRADING JOURNAL'!$E$11:$E$1070,M3)

file attached

Thanks heaps!

Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 18, 2022

    Ding080 

    you need to create dynamic ranges. If imitate on such model

    we may create two named formulae for dynamic ranges

    Here they are

    =Sheet1!$D$3:INDEX(Sheet1!$D$3:$D$99, COUNTA(Sheet1!$D$3:$D$99) )
=Sheet1!$E$3:INDEX(Sheet1!$E$3:$E$99, COUNTA(Sheet1!$D$3:$D$99) )

    Right click on the chart, Select Data and update Series and X Axis like

     

Resources