| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
3 results possible on every day. add up the number of each on each day.
Hello,
Am Mon, 23 Jan 2012 22:45:50 +0100 schrieb Claus Busch: in B1: =SUMPRODUCT(--(Sheet1!A1:A200=A1),--(Sheet1!H1:H200="Y")) change the relative ranges to absolute ranges: =SUMPRODUCT(--(Sheet1!$A$1:$A$200=A1),--(Sheet1!$H$1:$H$200="Y")) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking the results of a number of IF formula | Excel Worksheet Functions | |||
| HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW | Excel Worksheet Functions | |||
| Vlookup results in a number? | Excel Discussion (Misc queries) | |||
| Negative number results to show as zero | Excel Discussion (Misc queries) | |||
| random number results | Excel Worksheet Functions | |||
Threaded Mode
