LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
shmurphing
 
Posts: n/a
Default complex fomula: counting cells that are blank

I have a range of cells that I need to count and they must meet certain
criteria. I have found that if the cell is blank, it will count it instead
of eliminating it from the criteria.

Here is the sumproduct formula I have been using:
=SUMPRODUCT(--('Wpg #s data'!C2:C642="Incident"),--('Wpg #s data'!G2:G642<D2))

I need to eliminate a count for cells that are blank in the G column.
Column G contains the date and time of the record. So, it should ask, is it
an incident, and is the date greater than a specific date, and eliminate it
in the count if it is null. Possible?
 
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
Non Blank - Blank Cells???? Reggie Excel Discussion (Misc queries) 3 January 12th 05 12:04 AM
Counting blank cells in Pivot Table Andy Joyce Excel Worksheet Functions 1 December 21st 04 10:05 PM
In Exel 2000, stop the blank cells (with formulas) from printing. tonyoc Excel Discussion (Misc queries) 1 December 10th 04 12:38 AM
how to skip the blank cells nayeemoddin Excel Discussion (Misc queries) 1 December 6th 04 07:07 AM
Automatic copying data excluding blank cells Wesley Excel Worksheet Functions 6 November 30th 04 01:17 AM


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