Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default count multi lines

I would like to count the number and base on 3 columns data.
I try countif, but it seems only support one column criteria.

Any information is great appreciated,

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default count multi lines

Can you provide a little more information please... what are your "if"
conditions for each column (and any other condition you may be imposing)?

--
Rick (MVP - Excel)


"inungh" wrote in message
...
I would like to count the number and base on 3 columns data.
I try countif, but it seems only support one column criteria.

Any information is great appreciated,


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default count multi lines

Can you provide a little more information please... what are your "if"
conditions for each column (and any other condition you may be imposing)?

--
Rick (MVP - Excel)


"inungh" wrote in message
...
I would like to count the number and base on 3 columns data.
I try countif, but it seems only support one column criteria.

Any information is great appreciated,


Reply
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
VBA Advanced Filter - latest lines for multi criteria Angus Excel Programming 3 May 20th 09 02:58 AM
Complex Multi-condition, multi-workbook count Heliocracy Excel Discussion (Misc queries) 0 October 4th 07 08:18 PM
Creating single lines of data from a multi-column table hywel Excel Discussion (Misc queries) 3 February 11th 05 10:32 PM
Msgbox w/ multi-lines jt46[_2_] Excel Programming 1 October 11th 04 07:57 PM
Msgbox w/ multi-lines jt46 Excel Programming 11 October 11th 04 08:55 AM


All times are GMT +1. The time now is 07:13 AM.

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

About Us

"It's about Microsoft Excel"