Sum based on date
 

Hello,
I have a worksheet that gets data from external source. I need to sum
numbers in Column C if date in Column B is = another cell.

I tried:
=IF(B:B=F2,SUM(C:C))
=SUMIF(B:B,B:B=F2,C:C)

Much appreciated.
--
Sherry N.

Sum based on date
 

Try this:

=SUMIF(B:B,"="&F2,C:C)


--
Biff
Microsoft Excel MVP


"Sherry N." wrote in message
...
Hello,
I have a worksheet that gets data from external source. I need to sum
numbers in Column C if date in Column B is = another cell.

I tried:
=IF(B:B=F2,SUM(C:C))
=SUMIF(B:B,B:B=F2,C:C)

Much appreciated.
--
Sherry N.

Sum based on date
 

PERFECT! Thanks a million!
--
Sherry N.


"T. Valko" wrote:

Try this:

=SUMIF(B:B,"="&F2,C:C)


--
Biff
Microsoft Excel MVP


"Sherry N." wrote in message
...
Hello,
I have a worksheet that gets data from external source. I need to sum
numbers in Column C if date in Column B is = another cell.

I tried:
=IF(B:B=F2,SUM(C:C))
=SUMIF(B:B,B:B=F2,C:C)

Much appreciated.
--
Sherry N.

Sum based on date
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Sherry N." wrote in message
...
PERFECT! Thanks a million!
--
Sherry N.


"T. Valko" wrote:

Try this:

=SUMIF(B:B,"="&F2,C:C)


--
Biff
Microsoft Excel MVP


"Sherry N." wrote in message
...
Hello,
I have a worksheet that gets data from external source. I need to sum
numbers in Column C if date in Column B is = another cell.

I tried:
=IF(B:B=F2,SUM(C:C))
=SUMIF(B:B,B:B=F2,C:C)

Much appreciated.
--
Sherry N.