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
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
Hi, can you be a bit more specific about what your requirements are?
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
=SUMIF(B:B,--"2005-08-01",D) that is D : DOriginally Posted by 070968
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Okay, read requiremnts in your file ..
Originally Posted by 070968Note 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.In G3 enter: AIR TRANSPORT COMPANY In H3 enter: 8/1/05 In I3 enter: =SUMPRODUCT((B2:B312=H3)*(C2:C312=G3),D2:D312)
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
A second qualifier existed, only specified in the workbook..Originally Posted by xld
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
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
That is what my formula does.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Hi,
I have used Autofilter & then the SUMPRODUCT formula given by you, it worked very well.
Thanks a lot for your help.
Regards
Garima
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