Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 3rd 04, 04:51 PM
Angel160
 
Posts: n/a
Default Countif, Sumif, If - help!


We are using a spreadsheet to log deals executed. Some of these are
bulk deals and are marked as such on the spreadsheet.

I need to count how many bulk deals we have carried out, which I can do
using CountIf and then I need to count how many of the bulk deals were
over 10,000 and this is where I am struggling. The CountIf formula
only counts one range (which I am using to count the actual number of
bulk deals) while the If formula only looks at one cell at a time,
which isn't what I want.

Has anyone any ideas?

Many thanks.


--
Angel160
------------------------------------------------------------------------
Angel160's Profile: http://www.excelforum.com/member.php...o&userid=15503
View this thread: http://www.excelforum.com/showthread...hreadid=274943


  #2   Report Post  
Old November 3rd 04, 05:15 PM
Jim
 
Posts: n/a
Default

u can try AND function with If & Countif together. check the syntax and i
believe it can be done this ways! or for more assistance give the example,
so i can write a formula for u

--
Hope it Helps!
Jim
India




"Angel160" wrote in message
...

We are using a spreadsheet to log deals executed. Some of these are
bulk deals and are marked as such on the spreadsheet.

I need to count how many bulk deals we have carried out, which I can do
using CountIf and then I need to count how many of the bulk deals were
over 10,000 and this is where I am struggling. The CountIf formula
only counts one range (which I am using to count the actual number of
bulk deals) while the If formula only looks at one cell at a time,
which isn't what I want.

Has anyone any ideas?

Many thanks.


--
Angel160
------------------------------------------------------------------------
Angel160's Profile:

http://www.excelforum.com/member.php...o&userid=15503
View this thread: http://www.excelforum.com/showthread...hreadid=274943



  #3   Report Post  
Old November 3rd 04, 05:23 PM
Aladin Akyurek
 
Posts: n/a
Default


Angel160 Wrote:
We are using a spreadsheet to log deals executed. Some of these are
bulk deals and are marked as such on the spreadsheet.

I need to count how many bulk deals we have carried out, which I can do
using CountIf and then I need to count how many of the bulk deals were
over 10,000 and this is where I am struggling. The CountIf formula
only counts one range (which I am using to count the actual number of
bulk deals) while the If formula only looks at one cell at a time,
which isn't what I want.

Has anyone any ideas?

Many thanks.


=SUMPRODUCT(--(MarkRange=BulkMark),--(DealsRange10000))


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274943



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
Subtotal And Countif Sheryl Excel Discussion (Misc queries) 4 December 9th 04 07:18 PM
countif, again Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM
combining countif formulas Liz G Excel Worksheet Functions 3 November 1st 04 09:34 PM
COUNTIF Question zbert Excel Worksheet Functions 2 October 31st 04 05:14 PM
CountIF across multiple sheets in a workbook Al Excel Worksheet Functions 1 October 29th 04 01:15 PM


All times are GMT +1. The time now is 12:49 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017