B
Bob Newman
I have a database with these fields (among others):
A: Date, B: Name, C: Address, D: Widgets
I have been using a sumif function to give me the number of widgets sold for
a given date. If a sale for that date contained widget sale it would always
be 1 for the quantity so the sumif function worked great. We are changing
so the value in that field will now be the widget's selling price (still
only one widget to a sale). But I need to COUNT the number of widgets and
no longer SUM the value in that field. I don't see how the COUNTIF function
will both look for a particular date and than look for widgets within that
date criteria.
Help please... Bob
A: Date, B: Name, C: Address, D: Widgets
I have been using a sumif function to give me the number of widgets sold for
a given date. If a sale for that date contained widget sale it would always
be 1 for the quantity so the sumif function worked great. We are changing
so the value in that field will now be the widget's selling price (still
only one widget to a sale). But I need to COUNT the number of widgets and
no longer SUM the value in that field. I don't see how the COUNTIF function
will both look for a particular date and than look for widgets within that
date criteria.
Help please... Bob
200)