Urgent Formula!

P

Peter Curtis

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!
 
J

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
 
J

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
Click to expand...

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

Regards,

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

Bob Phillips

See other post.

--

HTH

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