Posted to microsoft.public.excel.programming

bijan

external usenet poster

Posts: 44

Null cells

Hi Experts,
How can I define Null cells in first part of SUMPRODUCT function:

With ActiveSheet
Lrow = .Range("A" & .Rows.Count).End(xlUp).Row
.Range("C25:C" & Lrow).Formula = _
"=SUMPRODUCT((TEST!$B$10:$B$20000 IS
Null)*(TEST!$E$10:$E$20000=""NO"")*(SCH_COM!$G$10: $G$20000=""Yes"")*(TEST!$J$10:$J$20000))"
End With
Thanks in advance
Bijan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Failed to save table attributes of (null) into (null).	Luca Brasi	Excel Discussion (Misc queries)	2	February 4th 09 04:30 PM
cells with null or no data	Rpettis31	Excel Programming	2	November 13th 08 09:50 PM
NULL Cells	UnderCoverGuy	Excel Worksheet Functions	4	October 31st 06 07:33 PM
Checking that any cells are null	RFJ	Excel Worksheet Functions	5	June 21st 05 01:21 PM
Cells().value is null but I can see data	JohnEnnever	Excel Programming	1	January 8th 04 02:04 AM

All times are GMT +1. The time now is 10:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us