ExcelBanter - Sum a value

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

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

- - Sum a value (https://www.excelbanter.com/excel-worksheet-functions/224202-sum-value.html)

Jafferi[_2_]

Sum a value

How do I plant in a formula to sum up 1 Mar

Example:
C D
1 Mar - How do I fomulate this cell to sum cell B to equal to $12

A B
Date $
1 Mar 5.00
1 Mar 7.00
2 Mar 5.00
2 Mar 2.00

Mike H

Sum a value

Hi,

With the date to sum in C1 try this

=SUMIF(A2:A20,C1,B2:B20)

Mike

"Jafferi" wrote:

How do I plant in a formula to sum up 1 Mar

Example:
C D
1 Mar - How do I fomulate this cell to sum cell B to equal to $12

A B
Date $
1 Mar 5.00
1 Mar 7.00
2 Mar 5.00
2 Mar 2.00

All times are GMT +1. The time now is 03:51 PM.