View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich
 
Posts: n/a
Default 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