LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CountIf for multiple columns John English Excel Discussion (Misc queries) 2 February 1st 07 12:31 AM
Countif Using Multiple Columns Rob E Excel Worksheet Functions 4 January 24th 07 08:47 AM
Sum or Countif over Multiple Columns AndyO_UK Excel Worksheet Functions 3 December 1st 06 02:48 PM
using a countif with multiple columns [email protected] Excel Worksheet Functions 3 August 22nd 06 04:17 AM
Using Countif on multiple columns ingeman Excel Worksheet Functions 1 July 17th 06 06:08 AM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"