Conditonal sum in Excel

microsoft-excel libreoffice-calc openoffice-calc

Sounds like you could use SUMIF, e.g.

=SUMIF(A1:A30,"value",B1:B30)

Related

I've pluged e-pci power cable(6+2pin) to eps 8 pin on motherboard
Simple way to do dynamic but square layout
Countifs by consider dates range [closed]
Save all files in Visual Studio project as UTF-8
Microsoft Word switches fonts when I switch input language
How restore IP in the HP printer?
Virus disguising as file
How to interpret TCP/ip fingerprint when scanning for OS?
What are these "extra" punctuations on my keyboard and how to use them
USB 3.0 as display in for laptop
Tool to read all blocks from HDD and write it back
Automate keystrokes in Windows 7 64-bit