3 Replies - 273 Views - Last Post: 11 November 2017 - 07:27 AM Rate Topic: -----

#1 kyle01  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 197
  • Joined: 26-November 14

Excel Spreadsheet formula help

Posted 10 November 2017 - 02:08 PM

I have a excel spreadsheet but I am having trouble with an IF statement. This is what the IF statement is meant to do (is pseado code): IF(B2:B12 equals C2:12 then in C15 add the totals in A2:A12).

So, if e.g. B2 says "yes" and when I type "yes" in C2, in C15 it will add the value in A2 to whatever the current amount is. Which I can then use the drag feature to apply the same principle to the rest of the rows below.

These are the formulas I've tried already but I keep getting the #VALUE! message in the cell. I'm terrible with Excel spreadsheets, this would be a breeze in java -.-
=IF(B2:B12=C2:C12,A2:A12,"")



I was thinking to do something like:, but that just throws a error window
=IF(B2:B12=C2:C12,=SUM(A2:A12),"")



Can anybody help please?

Is This A Good Question/Topic? 0
  • +

Replies To: Excel Spreadsheet formula help

#2 kyle01  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 197
  • Joined: 26-November 14

Re: Excel Spreadsheet formula help

Posted 10 November 2017 - 02:21 PM

Edit: I used this but the value is 0 for some reason

=SUMIFS(A2:A12,B2:B12,”Yes”,C2:C12,”Yes”)



[url]https://ibb.co/ef5yqw[/url]
Was This Post Helpful? 0
  • +
  • -

#3 andrewsw  Icon User is offline

  • the case is sol-ved
  • member icon

Reputation: 6379
  • View blog
  • Posts: 25,774
  • Joined: 12-December 12

Re: Excel Spreadsheet formula help

Posted 11 November 2017 - 12:13 AM

That SUMIFS formula is correct, apart from the unusual quote marks.
(Another reason it might not be working is if automatic calculation is switched off.)
Was This Post Helpful? 0
  • +
  • -

#4 kyle01  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 197
  • Joined: 26-November 14

Re: Excel Spreadsheet formula help

Posted 11 November 2017 - 07:27 AM

View Postandrewsw, on 11 November 2017 - 07:13 AM, said:

That SUMIFS formula is correct, apart from the unusual quote marks.
(Another reason it might not be working is if automatic calculation is switched off.)


ok it worked, i restarted excel and for some reason it just worked :)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1