Apr 19 2018
04:04 AM
- last edited on
Jul 25 2018
11:44 AM
by
TechCommunityAP
Apr 19 2018
04:04 AM
- last edited on
Jul 25 2018
11:44 AM
by
TechCommunityAP
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.
Apr 19 2018 04:15 AM
Hi Gemma,
It could be
=SUMIF($A$3:$A$11,"Apple",$C$3:$C$11)
Apr 26 2018 07:34 AM
That is amazing Sergei! Thank you for all your help that works perfectly. :)
Apr 26 2018 08:38 AM
You are welcome