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