| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Excel 2007 Formula
=SUM(COUNTIF(D36:D606,"$L5$L6$L7"))+(COUNTIF(H36:H 606,"hC"))
Trying to count the number of L5,L6,L7 in column range D36:D606, for a total count. Then I want that total number of L5,L6,L7 (one sum)to display the total hC count shown in column H36:H606. I can't seem to get the total number of hC for L5,L6,L7. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Formula and VBA help | Excel Discussion (Misc queries) | |||
| Formula bar - Excel 2007 | Excel Discussion (Misc queries) | |||
| formula excel 2007 | Excel Discussion (Misc queries) | |||
| I need a formula for excel 2007 | Excel Discussion (Misc queries) | |||
| excel 2007 formula | Excel Worksheet Functions | |||
Threaded Mode
