cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

IF function - Counting a range of cells based on another range's value

Gemma Telfer
Copper Contributor

‎Apr 19 2018 04:04 AM - last edited on ‎Jul 25 2018 11:44 AM by

‎Apr 19 2018 04:04 AM - last edited on ‎Jul 25 2018 11:44 AM by

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.

Untitled.png

 

568 Views
0 Likes
3 Replies
Reply
3 Replies
Sergei Baklan

‎Apr 19 2018 04:15 AM

‎Apr 19 2018 04:15 AM

Re: IF function - Counting a range of cells based on another range's value

Hi Gemma,

 

It could be

=SUMIF($A$3:$A$11,"Apple",$C$3:$C$11)
0 Likes
Reply
Gemma Telfer

‎Apr 26 2018 07:34 AM

‎Apr 26 2018 07:34 AM

Re: IF function - Counting a range of cells based on another range's value

That is amazing Sergei! Thank you for all your help that works perfectly. :)

0 Likes
Reply