Counting formula required

[becvec]

Hi,

I have 2 worksheets in the one spreadsheet. In worksheet called Data I have a list of names and in column C is either the word new or existing, in column E is either the value 1 or 0.

In the worksheet called totals I would like to have a formula that counts the values in column E if the word in column C = new and column E = 1

 

[edokhotnik]

Hi,

I have 2 worksheets in the one spreadsheet. In worksheet called Data I have a list of names and in column C is either the word new or existing, in column E is either the value 1 or 0.

In the worksheet called totals I would like to have a formula that counts the values in column E if the word in column C = new and column E = 1

Give this a try:

Excel Workbook
	B	C	D
2	Ed	New	1
3	Tom	Existing	0
4	George	Existing	1
5	Sarah	New	0
6	Fabiola	New	1
Data

Excel Workbook
	E
2	2
Excel 2010 Totals Sheet Totals

Excel 2010

Cell Formulas
Range	Formula
E2	=SUMPRODUCT(--(Data!C2:C6="New"),--(Data!D2:D6=1))

HTH, Ed

 

[Haseeb Avarakkan]

Try,

Excel 2007+

=COUNTIFS(Data!C:C,"New",Data!E:E,1)

Excel 2003-

=SUMPRODUCT(--(Data!C2:C1000="New"),--(Data!E2:E1000=1))