LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default SUMIF function problem

I have used this formula in the past (last month) without problems - now I
have copied the columns and tried to alter the formula - it keeps telling me
"you've entered too few arguments". My formula was SUMIF (AA3:AA180 "y"
X3:X180) - all I am trying to do is to change the 180 to 183 in AA and X. I
have tried setting the function using the wizard and the formula is exactly
the same and still gives the same error message. Please help.
 
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
Excel SUMIF function problem harperma Excel Worksheet Functions 3 December 17th 07 09:40 PM
SUMIF Function Problem Chad Excel Discussion (Misc queries) 3 June 22nd 07 11:24 PM
Problem in SUMIF Function Kelvin Lee Excel Discussion (Misc queries) 1 August 25th 06 05:06 AM
Problem adding a range using Sumif function. vrk1 Excel Worksheet Functions 2 June 22nd 05 06:05 PM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM


All times are GMT +1. The time now is 06:03 PM.

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"