Thread: Urgent Formula!
View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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!