Adding 2 colums of data
=SUMPRODUCT((Sheet3!C5:C35="name")*(LEFT(Sheet3!E5 :E35,1)="O"))
Count the number of rows with colC = "name" and the text in Column E starts
with O
--
If this post helps click Yes
---------------
Jacob Skaria
"Mamagga" wrote:
Hi Jacob,
I used the formula below and a was somewhat successful - it added but not
the right total. Maybe if you explained the formula (ie. what is "left" for
and the ,1 after the array?) I could figure it out.
Thaks
"Jacob Skaria" wrote:
Try
=SUMPRODUCT((Sheet3!C5:C35="name")*(LEFT(Sheet3!E5 :E35,1)="O"))
If this post helps click Yes
---------------
Jacob Skaria
"Mamagga" wrote:
I would like to count 2 colums of data for a sum
Ex: =countif((Sheet3!C5:C35="name")*(Sheet3!E5:E35="O* *"))
Please advise.
|