Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF arguments
hello... i am attempting to make a sprdsheet related to work on Excel 97 and
i need a cell to show how many items there are of a set type using to arguments.... for example, my A:A column is date, and my K:K column is refunds, i need it to count how many 'yes' values are showing in the refund column for a certain date. i can make it count 'yes' values, and i can make it count how many items on a date but cant seem to get it to use both criteria to get a result. any assistance would be greatly appreciated. -- - Rich |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF arguments
=sumproduct(--(a1:A100=date(2005,12,31)),--(k1:k100="yes"))
Adjust the range to what you want, but you can't use the whole column. =sumproduct() likes to work with numbers. The -- stuff changes trues to 1's and falses to 0's. Rich wrote: hello... i am attempting to make a sprdsheet related to work on Excel 97 and i need a cell to show how many items there are of a set type using to arguments.... for example, my A:A column is date, and my K:K column is refunds, i need it to count how many 'yes' values are showing in the refund column for a certain date. i can make it count 'yes' values, and i can make it count how many items on a date but cant seem to get it to use both criteria to get a result. any assistance would be greatly appreciated. -- - Rich -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF arguments
If you have quite a few entries, you might consider using a Pivot Table:
First, make sure you have column headings: Data, Customer, etc DataPivot Table Use Excel List Select your data range Click the [Layout] button ROW: Drag the Date field here Dbl-Click that field and set subtotals to None Drag the Refunds field here (Col_K heading?) Dbl-Click that field and set subtotals to None DATA: Set to Count of Refunds Then Click the [OK] button Select a place for your Pivot Table...done Does that help? *********** Regards, Ron "Rich" wrote: hello... i am attempting to make a sprdsheet related to work on Excel 97 and i need a cell to show how many items there are of a set type using to arguments.... for example, my A:A column is date, and my K:K column is refunds, i need it to count how many 'yes' values are showing in the refund column for a certain date. i can make it count 'yes' values, and i can make it count how many items on a date but cant seem to get it to use both criteria to get a result. any assistance would be greatly appreciated. -- - Rich |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF arguments
thank you!! i have been trying to solve this for ages... wonderful help. much
appreciated. -- - Rich "Dave Peterson" wrote: =sumproduct(--(a1:A100=date(2005,12,31)),--(k1:k100="yes")) Adjust the range to what you want, but you can't use the whole column. =sumproduct() likes to work with numbers. The -- stuff changes trues to 1's and falses to 0's. Rich wrote: hello... i am attempting to make a sprdsheet related to work on Excel 97 and i need a cell to show how many items there are of a set type using to arguments.... for example, my A:A column is date, and my K:K column is refunds, i need it to count how many 'yes' values are showing in the refund column for a certain date. i can make it count 'yes' values, and i can make it count how many items on a date but cant seem to get it to use both criteria to get a result. any assistance would be greatly appreciated. -- - Rich -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
How do I set up an array using countif for 2 separate arguments. | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |