Solved: SUMIF

[070968]

HI,

I need sum of Amounts of a party on a specific date within a range. I have attached my work file. Please help me to solve this!

Thanks

[Zack Barresse]

Hi, can you be a bit more specific about what your requirements are?

[Bob Phillips]

HI,

I need sum of Amounts of a party on a specific date within a range. I have attached my work file. Please help me to solve this!

Thanks

=SUMIF(B:B,--"2005-08-01",D) that is D : D

[Zack Barresse]

Okay, read requiremnts in your file ..

I need sum of Amounts of a party say "AIR TRANSPORT COMPANY", On a specific date say Sum of amounts on 1st Aug 2005 = 19992

In G3 enter:
AIR TRANSPORT COMPANY

In H3 enter:
8/1/05

In I3 enter:
=SUMPRODUCT((B2:B312=H3)*(C2:C312=G3),D2:D312)

Note the ranges must be exactly the same and this particular formula does not grow with your data. As it wasn't a specified requirement I didn't add it, but it can be done.

[Zack Barresse]

=SUMIF(B:B,--"2005-08-01",D) that is D : D

A second qualifier existed, only specified in the workbook..

[070968]

Hi,

I want to add all common data from a given range.

example:

in c1:c200 search a party name,
in B1:B200 search similar dates of searched party from C1:C200

now add all corresponding amounts from D1200 of a date.

thanks

[Zack Barresse]

That is what my formula does.

[070968]

Hi,

I have used Autofilter & then the SUMPRODUCT formula given by you, it worked very well.
Thanks a lot for your help.

Regards

Garima

[yogeshwarv]

What the Formula would be if Vlookup is to be applied on the same problem
i.e if someone wants to look the amount of air transport company on a specific date i.e. 1-8-5 what would be the formula