Remember Me?

#1
November 3rd 04, 04:51 PM
 Angel160 Posts: n/a
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

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

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

#3
November 3rd 04, 05:23 PM

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))

--
------------------------------------------------------------------------

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Sheryl Excel Discussion (Misc queries) 4 December 9th 04 07:18 PM Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM Liz G Excel Worksheet Functions 3 November 1st 04 09:34 PM zbert Excel Worksheet Functions 2 October 31st 04 05:14 PM Al Excel Worksheet Functions 1 October 29th 04 01:15 PM

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