Sum if for multiple criteria

[laundrymatic]

---

---

I need a formula which can sum the mode of payments seperately occuring on different dates.
Please see the attachme.it is like



table 1

date cash crdit card
1-1-14
2-1-14
3-1-14


table 2

product booking date booking amount payment date payment amount Payment Mode

a 1-1-14 100 2-1-14 100 credit card
b 1-1-14 150 3-1-14 150 cash
c 2-1-14 200 3-1-14 200 credit card


i want to add value in table 1 from table 2.

In front of date CELL Both cash and credit card amounts should appear separately.

 

[dispelthemyth]

Try sumifs

=sumifs(sumrange, criteria range 1, criteria 1, criteria range 2, criteria 2)


I'm on a mobile ATM so can't help beyond that


If you need more help as no one else has replied I'll take a look later on



Graeme

---

---

I need a formula which can sum the mode of payments seperately occuring on different dates.
Please see the attachme.it is like



table 1

date cash crdit card
1-1-14
2-1-14
3-1-14


table 2

product booking date booking amount payment date payment amount Payment Mode

a 1-1-14 100 2-1-14 100 credit card
b 1-1-14 150 3-1-14 150 cash
c 2-1-14 200 3-1-14 200 credit card


i want to add value in table 1 from table 2.

In front of date CELL Both cash and credit card amounts should appear separately.

 

[arthurbr]

Cross post Sum if formula for two different criteria

Poster does not care about forum rules