Anyone know Excel?

[Runningdemon]

Trying to streamline my crafting records file and can only start at help files so long trying to teach myself things wondering why what I am telling it to do does not work.

Anyway, my file has 2 tabs, first is the master spreadsheet with all data records. The second is where I am telling it to do calculations.

Anyone have any idea the kinda syntax I need to make the second sheet SUM up all the results from previous page if the value of a certain column is xxx.

ex: D2-1345 are my data, how do I make the second sheet's calculation's SUM the values in the D column ONLY when the C column is xxx (earth/fire/other day)

And yeah I know how to make stuff go between tabs (filename!), but am tired and not gonna screw with it anymore tonight.

Thanks for any help.

[Tajin]

ADD.IF([matrix of values], [condition])


Not too sure, since its been a while since i had an english version of office

[Keltiks]

lookup "SUMIF"

[Runningdemon]

Ahhhhhhhh...SUMIF looks like the winner.

Knew about IF, but didn't ever see SUMIF.


Ty.