Countif, Sumif, If - help!

[Angel160]

We are using a spreadsheet to log deals executed. Some of these ar
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 d
using CountIf and then I need to count how many of the bulk deals wer
over £10,000 and this is where I am struggling. The CountIf formul
only counts one range (which I am using to count the actual number o
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

 

[Jim]

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

 

[Aladin Akyurek]

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),--(DealsRange>10000))