| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
using logical functions as criteria with the SUMIF function
I have a datatable with a number of columns and I want to add all the numbers
in column "S" when the text in column "M begin with an "A". I also want to use the same function for all the numbers in Cloumns "T", "U", "V", etc. I have tried =SUMIF($M$3:$M$100,LEFT($M3,1)="A",S3:S100) and all I get is "0". Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF Criteria | Excel Discussion (Misc queries) | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
| SUMIF with more than 1 criteria | Excel Worksheet Functions | |||
| How to load Engineering Functions into the Fx function wizard? | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
