# Sumif Formula With 2 Condition in Horizontal & Vertical

1. ## Sumif Formula With 2 Condition in Horizontal & Vertical

Hi,

Is there any to use sumif with 2 condition as horizontal & Vertical

Jan Feb Mar
A 1 2 3
B 5 10 15
C 4 8 12
B 1 2 3

Jan
B =

2. ## Re: Sumif Formula With 2 Condition in Horizontal & Vertical

Try
=SUMPRODUCT((B2:D5)*(B1:D1=A7)*(A2:A5=A8))
or
=SUMIF(A2:A5,A8,INDEX(B2:D5,,MATCH(A7,B1:D1,0)))
see the attached file

3. ## Re: Sumif Formula With 2 Condition in Horizontal & Vertical

Use SUMPRODUCT. see file.

4. ## Re: Sumif Formula With 2 Condition in Horizontal & Vertical

Thanks to all

5. ## Re: Sumif Formula With 2 Condition in Horizontal & Vertical

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1