LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dave
 
Posts: n/a
Default How Do I have excel count 2 cells with conditions (Excel 2003)

2 columns (F & G) with several rows. Column €œF€ includes 7 code letters (C,E,
J, and etc.) for coding. Column G has only 2 codes. Either €œM€ or €œF€. I want
to show in a total box all the €œJ€ €œM€s in one cell (H36) and show all
total of €œJ€; €œF€s (H37) in another separate total cell discounting all
other codes C,E and etc from Column €œF€.

I hope this makes sense. Thank you.

 
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
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
Filling cells (autofil?) in Excel 2003 Hnelg Excel Discussion (Misc queries) 3 July 5th 05 02:47 PM
Excel 2003 will not display color fonts or color fill cells DaveC Excel Worksheet Functions 1 April 11th 05 04:38 PM
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free Florimar Agostini via OfficeKB.com Excel Discussion (Misc queries) 1 April 1st 05 06:29 AM


All times are GMT +1. The time now is 03:02 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"