| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to know how many times 2 corresponding cells meet a con
They just convert the Boolean values TRUE or FALSE into 1 or 0 thus you can
use SUMPRODUCT's built in format as opposed to multiplying the ranges with each other. You can use 0+ or 1* or N as well -- Regards, Peo Sjoblom http://nwexcelsolutions.com "talderman" wrote in message ... Thank you I appreciate it those of you who replied. What does the -- mean I'm not familiar with those -- Tim "Dave O" wrote: =SUMPRODUCT(--(A1:A3=1),--(B1:B3=2)) The 1 and the 2 are hardcoded into this formula, but can just as easily reference other cells with those values. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill cells with times | Excel Worksheet Functions | |||
| Excel 2003, which formula will count the cells that meet 2 conditi | Excel Worksheet Functions | |||
| counting cells in a data range that meet 3 specific conditions | Excel Discussion (Misc queries) | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| Can you limit the amount of times a calc is performed on certain cells | Excel Discussion (Misc queries) | |||
Threaded Mode
