Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 829
Default Sumproduct not working

"joeu2004" wrote (with errata):
=COUNTIFS(B2:B6,"*4PM-6PM Start*",A2:A6,"<")

[....]
Caveat: The condition "<" might not work exactly A2:A6<"" above, IIRC.
Experiment to be sure that it counts all the instances you want, and it
does not count instances you do not want.

Alternatively (works in all Excel versions):
=SUMPRODUCT(ISNUMBER(SEARCH("4PM-6PM Start",B2:B6))*(A2:A6<""))


COUNTIF(A1:A1,"<") is 0 only for any empty cells; that is, no formula and
no constant value. It is one for cells whose value is the null string.

SUMPRODUCT(--(A1:A1<"")) is 0 for empty cells as well as for cells whose
value is the null string.

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
sumproduct not working bigproblem Excel Discussion (Misc queries) 2 March 8th 10 11:57 PM
Sumproduct not working Curtis Excel Worksheet Functions 3 November 6th 09 04:20 AM
SUMPRODUCT not working. Gaurav[_4_] Excel Worksheet Functions 2 June 25th 09 09:37 PM
SUMPRODUCT Not Working dj479794 Excel Discussion (Misc queries) 2 March 12th 07 12:54 PM
sumproduct not working Tester Excel Worksheet Functions 10 November 26th 06 09:58 PM


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