Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 05, 04:26 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2005
Posts: 1
Default 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   Report Post  
Old May 23rd 05, 08:28 PM
Ola
 
Posts: n/a
Default

One option is to use =SUMPRODUCT(...)
=SUMPRODUCT((A1:A1000="Name")*(D11000="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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I use the sumif if I have multiple criteria (i.e. greater . Kellyatisl Excel Worksheet Functions 3 June 4th 06 06:33 AM
nested sumif or sumif with two criteria dshigley Excel Worksheet Functions 5 April 5th 05 03:34 AM
"criteria" in a sumif refering to the value in another cell mark Excel Discussion (Misc queries) 1 January 31st 05 07:39 PM
How do I ask for multiple criteria when creating a "sumif" formul. Rachelle Excel Worksheet Functions 3 December 1st 04 11:49 PM
Can I use a cell reference in the criteria for the sumif function. Number Cruncher Excel Worksheet Functions 2 November 4th 04 07:52 PM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017