Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF with 2 criteria PLEASE HELP
I've done some searching and everything I find does not work... so I thought I would create an account and post my exact situation-
Column A contains Names and is VERY long and is not exactly the same length from one report to the next Column D contains Section numbers is also very long Column J contains numbers I need to sum (again very long) if column A contains the name I list and D contains the section number I enter. The catch may be that I need to use a wildcard into the formula for the data in column D as it is quite lengthy and often contains a -. For example one of the sections is 3.8.2.15.1.8.12.0-1 See why I would want to use wildcards? Thanks in advance for any assistance any of you could offer. With Gratitude, Dennis |
#2
|
|||
|
|||
One option is to use =SUMPRODUCT(...)
=SUMPRODUCT((A1:A1000="Name")*(D1:D1000="Section No")*(J1:J1000)) Hope it helps Ola Sandström Note: True*True*8=8 True*False*8=0 =SUMPRODUCT(8+0+.....+15) ....and Wildcards shouldn't be any problem |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |