LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default sumif when criteria range is larger but includes criteria

Trying to sum values when the criteria range (text) is larger (more
characters) but includes the criteria. Example: Sumif(A1:A10,"BOS",B1:B10)
to also include B2 in sum when criteria range cell A2 is "BOS-336".

Regards,
JoeR
 
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
countifs criteria includes date range JayH Excel Worksheet Functions 4 February 3rd 10 01:19 AM
sumif when criteria range is larger but includes criteria Joe1939 Excel Programming 1 January 16th 09 07:41 PM
Can I use a named range in the criteria for a sumif? rftmst Excel Worksheet Functions 2 September 1st 07 03:50 PM
sumif when criteria is a range jeremy via OfficeKB.com Excel Discussion (Misc queries) 7 August 15th 05 05:49 PM
SUMIF with AND for range and criteria davidm_ba Excel Worksheet Functions 3 August 2nd 05 01:31 PM


All times are GMT +1. The time now is 02:17 AM.

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

About Us

"It's about Microsoft Excel"