Urgent Formula!
 

I would like to count the text in a column (COUNTIF (A:A,"Monday")) then for
it to add a figure from another cell / column if it meets the text criteria
(eg. Monday) from the column


Thanks!

Hi Peter

not really sure of what you're after, but maybe

=IF(COUNTIF(A:A,"Monday")1,COUNTIF(A:A,"Monday")+ B1,0)

or
=COUNTIF(A:A,"Monday")+IF(B1="Monday",10,0)

Cheers
JulieD

"Peter Curtis" wrote in message
...
I would like to count the text in a column (COUNTIF (A:A,"Monday")) then
for
it to add a figure from another cell / column if it meets the text
criteria
(eg. Monday) from the column


Thanks!

Hi Peter,

I would like to count the text in a column (COUNTIF (A:A,"Monday")) then for
it to add a figure from another cell / column if it meets the text criteria


=SUMIF(A:A,"Monday",C:C)

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

See other post.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peter Curtis" wrote in message
...
I would like to count the text in a column (COUNTIF (A:A,"Monday")) then
for
it to add a figure from another cell / column if it meets the text
criteria
(eg. Monday) from the column


Thanks!

If I understand correctly
if(yourcountifformula0,a1,"")

--
Don Guillett
SalesAid Software

"Peter Curtis" wrote in message
...
I would like to count the text in a column (COUNTIF (A:A,"Monday")) then
for
it to add a figure from another cell / column if it meets the text
criteria
(eg. Monday) from the column


Thanks!