SUMIFS but not sure.

[TaffyIOM]

Hi guys please can you help, I have to show the total of income from memberships for each month either from Cash,Cheque,Card or Bacs each separately, and I'm too much of an amatuer to get a solution on how to do this using the SUMIF, SUMIFS I have tried for three days and keep getting not using enough criteria or to many criteria, I'm new to all this stuff but trying to get my head around it, Thanking you in advance Taffy included is a picture of the excel sheet I'm using (not sure how to upload to share it so you can play with it... again any help in this would be great
)

SDOFA_2020_2021.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Membership #	Membership Fee & Type	Donation	Fee Type	Date		Total Each MONTH	Total BACS	Total CASH	Total CHEQUE	AMOUNT	DIVIDE BY 4	VAT @ 20%	Total DONATION Exempt of VAT
2	001	NA	NA	NA	01/01/2020		JAN				£0.00	£0.00	£0.00	£55.00
3	002	10.00		Cash	08/01/2021		FEB				£0.00	£0.00	£0.00
4	003	15.00		Card	01/12/2020		MAR				£0.00	£0.00	£0.00
5	004	10.00		Cash	01/12/2020		APR				£0.00	£0.00	£0.00
6	005	15.00		Bacs	08/12/2020		MAY				£0.00	£0.00	£0.00
7	006	10.00		Cheque	08/01/2021		JUN				£0.00	£0.00	£0.00
8	007	Free	5.00	Cash	08/01/2021		JUL				£0.00	£0.00	£0.00
9	008	Free			13/02/2021		AUG				£0.00	£0.00	£0.00
10	009	10.00		Card	16/03/2021		SEP				£0.00	£0.00	£0.00
11	010	10.00		Bacs	01/12/2020		OCT				£0.00	£0.00	£0.00
12	011						NOV				£0.00	£0.00	£0.00
13	012						DEC				£0.00	£0.00	£0.00
14	013
15	014
16	015
17	016	15.00		Card	01/12/2020
18	017
19	018
20	019
21	020
22	021	10.00		Bacs	13/02/2021
23	022	10.00		Bacs	13/02/2021
24	023
25	024
26	025
27	026
28	027
29	028
30	029	Free	20.00	Bacs	16/04/2021
31	030
32	031
33	032
34	033	10.00		Cheque	11/02/2021
35	034
Sheet2

Cell Formulas
Range	Formula
K2:K13	K2	=SUM(H2:J2)
L2:M13	L2	=IF(K2="","",(K2/4))
N2	N2	=SUM(C2:C101)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C11,C14:C1048576	Cell Value	contains "20"	text	NO
C1:C11,C14:C1048576	Cell Value	contains "10"	text	NO
C2:C11,C14:C101	Cell Value	contains "5"	text	NO
B2:C11,B14:C101	Cell Value	contains "15"	text	NO
B2:C11,B14:C101	Cell Value	contains "10"	text	NO
B2:C11,B14:C101	Cell Value	contains "Free"	text	NO

 

[sprigelz]

This sums the Membership & Fee Type only. Do you also need to include the Donation column?

Try these for the January Row;
Column H

=SUMIFS(B:B,E:E,">="&DATE(2021,1,1),E:E,"<="&DATE(2021,1,31),D:D,"bacs")

Column I

=SUMIFS(B:B,E:E,">="&DATE(2021,1,1),E:E,"<="&DATE(2021,1,31),D:D,"cash")

Column J

=SUMIFS(B:B,E:E,">="&DATE(2021,1,1),E:E,"<="&DATE(2021,1,31),D:D,"cheque")

Change the numbers within both Date functions to associate Feb, Mar, Apr, etc...
Date formula - Date(year,month,day)

 

[Fluff]

Another option

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Membership #	Membership Fee & Type	Donation	Fee Type	Date		Total Each MONTH	Total BACS	Total CASH	Total CHEQUE	AMOUNT	DIVIDE BY 4	VAT @ 20%	Total DONATION Exempt of VAT
2	1	NA	NA	NA	01/01/2020		01/01/2021	0	10	10	20	5	1.25	25
3	2	10		Cash	08/01/2021		01/02/2021	20	0	10	30	7.5	1.875
4	3	15		Card	01/12/2020		01/03/2021	0	0	0	0	0	0
5	4	10		Cash	01/12/2020		01/04/2021	0	0	0	0	0	0
6	5	15		Bacs	08/12/2020		01/05/2021	0	0	0	0	0	0
7	6	10		Cheque	08/01/2021		01/06/2021	0	0	0	0	0	0
8	7	Free	5	Cash	08/01/2021		01/07/2021	0	0	0	0	0	0
9	8	Free			13/02/2021		01/08/2021	0	0	0	0	0	0
10	9	10		Card	16/03/2021		01/09/2021	0	0	0	0	0	0
11	10	10		Bacs	01/12/2020		01/10/2021	0	0	0	0	0	0
12	11						01/11/2021	0	0	0	0	0	0
13	12						01/12/2021	0	0	0	0	0	0
14	13
15	14
16	15
17	16	15		Card	01/12/2020
18	17
19	18
20	19
21	20
22	21	10		Bacs	13/02/2021
23	22	10		Bacs	13/02/2021
24	23
25	24
26	25
27	26
28	27
29	28
30	29	Free	20	Bacs	16/04/2021
31	30
32	31
33	32
34	33	10		Cheque	11/02/2021
35	34
Data

Cell Formulas
Range	Formula
H2:H13	H2	=SUMIFS($B:$B,$D:$D,"Bacs",$E:$E,">="&$G2,$E:$E,"<="&EOMONTH($G2,0))
I2:I13	I2	=SUMIFS($B:$B,$D:$D,"Cash",$E:$E,">="&$G2,$E:$E,"<="&EOMONTH($G2,0))
J2:J13	J2	=SUMIFS($B:$B,$D:$D,"Cheque",$E:$E,">="&$G2,$E:$E,"<="&EOMONTH($G2,0))
K2:K13	K2	=SUM(H2:J2)
L2:M13	L2	=IF(K2="","",(K2/4))
N2	N2	=SUM(C2:C101)

 

[TaffyIOM]

This sums the Membership & Fee Type only. Do you also need to include the Donation column?

Try these for the January Row;
Column H

=SUMIFS(B:B,E:E,">="&DATE(2021,1,1),E:E,"<="&DATE(2021,1,31),D:D,"bacs")

Column I

=SUMIFS(B:B,E:E,">="&DATE(2021,1,1),E:E,"<="&DATE(2021,1,31),D:D,"cash")

Column J

=SUMIFS(B:B,E:E,">="&DATE(2021,1,1),E:E,"<="&DATE(2021,1,31),D:D,"cheque")

Change the numbers within both Date functions to associate Feb, Mar, Apr, etc...
Date formula - Date(year,month,day)

Thank you I will try these, I don't need to calculate donations as we don't pay vat on them.