SUMIF or SUMIFS

Status
Not open for further replies.

agentkramr

Board Regular
Joined
Dec 27, 2021
Messages
95
Platform
  1. Windows
i currently have a spreadsheet that is connected to an oracle database
WCI HMTN VIP.xlsm
ABCDEFGHIJKLM
111/4/21 11:24 AM11/5/2020 11:2411:00 AM2:00 PM5:00 PM8:00 PM6:00 PM
2
3
4 Time2022
5
6
7Friday, November 4, 202211:00 AM0
8VIP 0
9Regular
102:00 PM0
11VIP
12Regular
135:00 PM391
14VIP
15Regular
168:00 PM142533
17VIP
18Regular
2018 1 Hour Counts
Cell Formulas
RangeFormula
A1A1=NOW()-364
H1H1=NOW()-728
A7A7=TODAY()+1
B7B7=A7+I$1
C7,C16,C13,C10C7=SUMIF(ATTENDANCE!$B:$B,'2018 1 Hour Counts'!B7,ATTENDANCE!$I:$I)
C8C8=SUMIF(ATTENDANCE!$B:$B,'2018 1 Hour Counts'!B7,ATTENDANCE!$I:$J)
B10B10=A7+J$1
B13B13=A7+K$1
B16B16=A7+L$1
D16D16=SUM(C7:C16)


WCI HMTN VIP.xlsm
ABCDEFGHIJ
1EVENT_CODEEVENT_DATEATTENDANCEPRICEDATETIMEFORMULACALENDAR_FORMATVLOOKUP_ATTENDANCEColumn1
222HM1101A11/1/2022 17:00130.9911/1/20220.7083333330#REF!130.99
322HM1101A11/1/2022 17:00532.9911/1/20220.7083333330#REF!532.99
422HM1101A11/1/2022 17:00433.9911/1/20220.7083333330#REF!433.99
522HM1101A11/1/2022 17:001234.9911/1/20220.7083333330#REF!1234.99
622HM1101A11/1/2022 17:00339.9911/1/20220.7083333330#REF!339.99
722HM1101A11/1/2022 17:00854.9911/1/20220.7083333330#REF!854.99
822HM1101A11/1/2022 17:00457.9911/1/20220.7083333330#REF!457.99
922HM1101A11/1/2022 17:004859.9911/1/20220.7083333330#REF!4859.99
1022HM1101A11/1/2022 17:00862.9911/1/20220.7083333330#REF!862.99
1122HM1101A11/1/2022 17:007264.9911/1/20220.7083333330#REF!7264.99
1222HM1101A11/1/2022 17:001165.9911/1/20220.7083333330#REF!1165.99
1322HM1101A11/1/2022 17:009566.9911/1/20220.7083333330#REF!9566.99
1422HM1101A11/1/2022 17:0022969.9911/1/20220.7083333330#REF!22969.99
1522HM1101A11/1/2022 17:002374.9911/1/20220.7083333330#REF!2374.99
ATTENDANCE
Cell Formulas
RangeFormula
E2:E15E2=INT([@[EVENT_DATE]])
F2:F15F2=[@[EVENT_DATE]]-INT([@[EVENT_DATE]])
G2:G15G2=SUMIFS([ATTENDANCE],[DATE],">=2/1/2019",[DATE],"<=2/28/2019")
H2:H15H2=CONCATENATE(#REF!, " ", TEXT(F2, "HAM/PM"), " ", [@ATTENDANCE])
I2:I15I2=[@ATTENDANCE]
J2:J15J2=[@PRICE]


i am using a SUMIF to populate the total amount of attendance on the 2018 1 hour counts sheet right next to the times from the tab called attendance BUT if i want just the ones that are 74.99 and 39.99 to calculate price wise but opnly for thew date what doi i need to do ? everything else would calculate to regular
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Duplicate to: SUMIF Function

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top