| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count using 2 conditions, one of which being a "less than or equal to" - URGENT
I need a formula or a macro which will count using two conditions a range of cells. The problem i have one of the conditions is a "less than or equal to" a time. the formula below i have used but it gives a false count, either 0 or counts only one of the conditions =SUMPRODUCT((A1:A25="<=00:03")*(B1:B25="AM")) i have also used the 'Ctrl-shift-enter' aswel. any ideas?? -- SamGB ------------------------------------------------------------------------ SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263 View this thread: http://www.excelforum.com/showthread...hreadid=512601 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count using 2 conditions, one of which being a "less than or equal to" - URGENT
=SUMPRODUCT(--(A1:A25<=--"00:03"),--(B1:B25="AM"))
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "SamGB" wrote in message ... I need a formula or a macro which will count using two conditions a range of cells. The problem i have one of the conditions is a "less than or equal to" a time. the formula below i have used but it gives a false count, either 0 or counts only one of the conditions =SUMPRODUCT((A1:A25="<=00:03")*(B1:B25="AM")) i have also used the 'Ctrl-shift-enter' aswel. any ideas?? -- SamGB ------------------------------------------------------------------------ SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263 View this thread: http://www.excelforum.com/showthread...hreadid=512601 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count using 2 conditions, one of which being a "less than or equal to" - URGENT
Excellent! works like a treat :) Many Thanks Sam -- SamGB ------------------------------------------------------------------------ SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263 View this thread: http://www.excelforum.com/showthread...hreadid=512601 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT using multiple conditions | Excel Discussion (Misc queries) | |||
| Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
| COUNT IF NOT EQUAL TO ZERO | Excel Worksheet Functions | |||
| Count the occurence of multiple (4 conditions). - Need urgent help | Excel Discussion (Misc queries) | |||
| How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
Linear Mode
