| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Countif to work like Sumif
I am trying to use the formula =Sumif(B7:B203,"Paul
G",(COUNTIF(C7:C203,"*"))) to count the number of cells in the "C" column which contains text and are in the same row next to my name in the "B" column. This formula does not work. Ay suggestions? Thank you, paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
| COUNTIF doesnt work! | Excel Worksheet Functions | |||
| problems with sumif and countif | Excel Discussion (Misc queries) | |||
| formula SUMIF or whichever one will work for my issue | Excel Worksheet Functions | |||
| How do I use ">$E$5" as the criteria using SUMIF and have it work. | Excel Worksheet Functions | |||
Threaded Mode
