Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > How do I use sumifs -
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 1
Default How do I use sumifs -
I want to use sumifs to find the results. For range A1:A100, If value in
column A = column C (a1=c1, or a2=c2,etc), then sum up Range A1:A100. How do
I do that?

Thanks
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 3,718
Default How do I use sumifs -
=SUMPRODUCT(--(A1:A100=C1:C100),A1:A100)


"wantfit" wrote:

I want to use sumifs to find the results. For range A1:A100, If value in
column A = column C (a1=c1, or a2=c2,etc), then sum up Range A1:A100. How do
I do that?

Thanks
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

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
Using Sumifs tomferrin Excel Worksheet Functions 3 April 7th 09 06:40 PM
Sumifs & Not Like Cow Girl Excel Discussion (Misc queries) 6 March 13th 09 08:34 PM
SUMIFS Steen Excel Worksheet Functions 5 November 2nd 08 03:38 PM
SUMIFS and OR mohavv Excel Discussion (Misc queries) 4 January 30th 08 04:02 PM
SUMIFS and OR M.S. Westerbeek Excel Worksheet Functions 6 August 23rd 07 07:24 PM


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

 

Contact Us ExcelBanter forum home Privacy Statement