Sumif

[Angel160]

Sorry if first q wasn't too clear.
My spreadsheet shows trades in various companies over the previou
calender month.

ie.
Column A: Date, Column B:Company, Coulumn C: No. of shares

I need to a fuction to show how many shares were traded in the las
week and in a particular company. I've got as far as:

=SUMIF(A1:A100,">="&TODAY()-7,C1:C100)

But now need to cross reference that to a particular company.

Cheer

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100>=TODAY()-7),--(B1:B100="Company Name"),C1:C100)

also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[JulieD]

Hi Angel

use the SUMPRODUCT function

=SUMPRODUCT(--(A1:A100>=TODAY()-7),--(B1:B100="AAA"),C1:C100)

where "AAA" is the name of the company you are interested in.

check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

for details on how the sumproduct function works

Cheers
JulieD

 

[evil man]

you are as boring as my ****ING shit. which is brown and stinks lik
your face