ExcelBanter - How do I sum Column F if Column B = "DEPOSIT"

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I sum Column F if Column B = "DEPOSIT" (https://www.excelbanter.com/excel-worksheet-functions/25959-how-do-i-sum-column-f-if-column-b-%3D-%22deposit%22.html)

Marvin

How do I sum Column F if Column B = "DEPOSIT"

How can you get a total of Column F if Column B contains the word deposit

Bob Phillips

=SUMIF(F:F,"Deposit",B;B)

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Marvin" wrote in message
...
How can you get a total of Column F if Column B contains the word deposit

Peo Sjoblom

=SUMIF(B2:B100,"*deposit*",F2:F100)

regards,

Peo sjoblom

"Marvin" wrote:

How can you get a total of Column F if Column B contains the word deposit

All times are GMT +1. The time now is 07:21 AM.