Forum Discussion
IF function - Counting a range of cells based on another range's value
Hi Can anyone help with this formula at all? I would like the formula to calculate the contents in column C if the word in column a is true and then report these on a separate worksheet. So if I...
Hi Gemma,
It could be
=SUMIF($A$3:$A$11,"Apple",$C$3:$C$11)
That is amazing Sergei! Thank you for all your help that works perfectly. :)
You are welcome
