Kraken
Reputation: 295
Excluding specific values from a range of cells
I would like to remove #N/A values from being counted in my sparklines. #N/As are produces with =NA().
My formula is =SPARKLINE(D5:AN5, {"ymin", 0}).
How do I exclude specific values from the "D5:AN5" range? I can't seem to find a way to do it.
Upvotes: 1
Views: 4148
Answers (1)
Max Makhrov
Reputation: 18707
Try filtering data:
=SPARKLINE(FILTER(D5:J5,ISNA(D5:AN5)=false), {"ymin", 0})
Upvotes: 1
Related Questions
- Exclude multiple cells from range
- Google Sheets - Filtering out values in a range from another range
- Formula in VBA, putting a formula in a range of cells but excluding certain cells
- How do I make Google Sheets ignore my data in certain cells?
- Create a list of values from a table of values and exclude certain values
- How to get certain Items out of Range in VBA
- Exclude dates from a range in google spreadsheets
- Filter a Range with values which I don't want
- How to exclude values in excel
- Omit specific values from a named range in Excel