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: 273
Default Same row conditional logic (count help)

I need help (if it's even possible) to have a running count of total items
that meet a certain criteria within the same row (for the entire worksheet).
For example:

A B
C D
1 Item Area Summary Area 1
2 Panasonic 1
3 Toshiba 2 Laptop Issues
2
4 Panasonic 1 Scanner Issues
1
5 Scanner 4

I need to know the formula to put into cell D3 to have it auto-count a total
based on the same row values from columns A and B. Based on that formula I'm
hoping to figure out the other items I need to do this for.

Thanks in advance for any help you can provide...!




 
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
USING DATA VALIDATION WITH CONDITIONAL LOGIC Data Validation AND Conditional Logic? Excel Discussion (Misc queries) 2 September 28th 07 05:09 PM
Unexpected Result with "If" Logic/Conditional Statement Bill Ridgeway Excel Discussion (Misc queries) 1 July 3rd 07 07:07 PM
In Excel, can Boolean logic be applied to conditional formatting? PeterL Excel Worksheet Functions 3 October 26th 06 08:16 PM
logic that returns a count d_kight Excel Discussion (Misc queries) 8 May 18th 06 12:30 AM
Count logic question ACDenver Excel Discussion (Misc queries) 7 August 17th 05 04:28 PM


All times are GMT +1. The time now is 09:56 PM.

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"