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 am looking for the total costs of apples altogether I want it to check then count all the apple values ignoring the carrot and bananas. So my answer would be £79.50.
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
