Urgent Formula!

[Guest]

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!

 

[JulieD]

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

 

[Jan Karel Pieterse]

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

 

[Bob Phillips]

See other post.

--

HTH

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

 

[Don Guillett]

If I understand correctly
if(yourcountifformula>0,a1,"")