ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I isolate only one row in the criteria for the dsum functi. (https://www.excelbanter.com/excel-worksheet-functions/18698-how-do-i-isolate-only-one-row-criteria-dsum-functi.html)

lxnv

how do I isolate only one row in the criteria for the dsum functi.
 
two entries for criteria

how do I isolate the second entry when I utilize the dsum() function? I can
only sum the values for both entries.

Debra Dalgleish

You can't select only the second criteria in the criteria area. You
could set up a new criteria area for the DSUM, with only the entry that
you need.

lxnv wrote:
two entries for criteria

how do I isolate the second entry when I utilize the dsum() function? I can
only sum the values for both entries.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com