How to use SUMIF Forumula in this condition

**dalipsinghbisht** · 10-14-2008, 02:21 PM

Please see the attached file

I want to use sumif formula with criteria in column E & Column F when I type in E, "done" and F "Vh" than some the Data of Column B.

Thanks
Kamal Singh

**Ron Coderre** · 10-14-2008, 02:27 PM

Using your posted file....
try this:

Please Login or Register  to view this content.

Copy that formula down as far as needed.

Is that something you can work with?

**VBA Noob** · 10-14-2008, 02:40 PM

Another option

=IF(E2&F2="Wipvh","Done","Open")

VBA Noob

**dalipsinghbisht** · 10-14-2008, 03:11 PM

Hey man i am asking the formula "sumif" in this case....

Please help....

**VBA Noob** · 10-14-2008, 03:21 PM

Sumif for Done

=SUMIF(G:G,"Done",B:B)

HTH

VBA Noob

**dalipsinghbisht** · 10-14-2008, 04:00 PM

=SUMIF(G:G,"Done & Wip",B:B)

Please tell how can the above formula will be correct....

Please once more time help

Thanks

**VBA Noob** · 10-14-2008, 04:07 PM

Try

=SUMPRODUCT((E2:E4="Wip")*(G2:G4="Done")*(B2:B4))

Change range as required. Note Sumproduct can't work on whole column

see link for more on sumproduct

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

VBA Noob