| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating a total with 3 different criterias
Formula: =COUNTIFS(B:B,"AS2",D:D,"MCT")
In column E (Total amount) - I have dollar values. I want to count all the cells in this column that has a "$" sign. Or... I want the formula to subtract any blank cells in this column so that it gives me a total number. I've tried to use: =COUNTIFS(B:B,"AS2",D:D,"MCT",E:E,"$") - RESULT: "0" (Which is incorrect) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Total Return | Excel Discussion (Misc queries) | |||
| Calculating total time | Excel Worksheet Functions | |||
| calculating total time | Excel Discussion (Misc queries) | |||
| total of certain cells using 2 criterias | Excel Worksheet Functions | |||
| CALCULATING CELLS AS A TOTAL | Excel Discussion (Misc queries) | |||
Threaded Mode
