View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chart_Maker_Wonderer Chart_Maker_Wonderer is offline
external usenet poster
 
Posts: 23
Default Countif for multiple columns

I am looking for a countif formula to be setup so it will check 2 columns and
do a running count of two conditions.

I want it to count if 1 column has something in it and the second column
needs to have a specific content.

Ie. Working on inventory chart that will need to have something in the
'description' field and then in the 'site' field the person will put the site
in there. I am working on a summary chart that will have it be count how many
times that there is something in the description field and Site 1 in the site
field. Then I will have another line that will be count how many times that
there is something in the description field and Site 2 in the site field