LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
K K is offline
external usenet poster
 
Posts: 108
Default Sumif with more than one criteria

OK, pls can someone help before my comp goes out of the window!!! I need to
sum up a value if my cells meet 2 Criteria - I thought I had it using an Aray
but juet got the Value error message. Anyways I have 3 col's as below

Town month & Days - I need a formula to add up the days when the town &
Month Match I thought =SUM((A2:A10=€¯Town X€¯)*(B2:B10=€¯Jan€¯)*C2:C10) would
work giving me the total of Col c when Col A was Town X & B was the month of
Jan
 
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
sumif with 2 criteria sumif and Excel Worksheet Functions 3 March 6th 08 10:15 PM
Sumif not criteria CCrew2000 Excel Worksheet Functions 8 June 6th 07 05:36 PM
sumif with criteria Tiya Excel Worksheet Functions 1 August 10th 06 02:14 PM
nested sumif or sumif with two criteria dshigley Excel Worksheet Functions 5 April 5th 05 03:34 AM
Criteria with "<" or ">" in sumif() Loan Excel Discussion (Misc queries) 3 February 14th 05 01:07 PM


All times are GMT +1. The time now is 10:03 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"