LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jim
 
Posts: n/a
Default =SUMPRODUCT and =IF

I currently use the following to count the number of occurrences that time
shows on my report. This is a great formula.

=SUMPRODUCT((AB3:AB10000=TIME(6,45,0))*(AB3:AB100 00<=TIME(7,29,59)))

What I need in its place is a formula that counts the occurrences of time
only if the cell next to the time shows a 1.

example:

A B
7:54:34 2
8:28:40 1
8:50:16 2
9:32:07 2
10:10:36 2
10:11:02 1

I only want to count a time period only if there is a number one in the next
cell.

Thanks for the help

 
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



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