PDA

View Full Version : Solved: SUMIF



070968
11-09-2005, 12:04 PM
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
11-09-2005, 12:23 PM
Hi, can you be a bit more specific about what your requirements are?

Bob Phillips
11-09-2005, 12:24 PM
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:D) that is D : D

Zack Barresse
11-09-2005, 12:29 PM
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
11-09-2005, 12:30 PM
=SUMIF(B:B,--"2005-08-01",D:D) that is D : D
A second qualifier existed, only specified in the workbook..

070968
11-09-2005, 12:44 PM
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 D1:D200 of a date.

thanks

Zack Barresse
11-09-2005, 12:56 PM
That is what my formula does.

070968
11-12-2005, 04:52 AM
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
11-14-2005, 12:45 AM
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