Mar 31 2021 11:14 PM
Hi,
I have a tab of data which shows "units on" & "units off" for each account for the month.
I wish to find the units off and on for certain dates. I am hoping to have this in a summary tab for selected accounts (HRN). As such i am hoping to match via the date and account (HRN).
Can someone please assist with this?
Greatly appreciate any assistance.
Apr 01 2021 12:34 AM
SolutionSee if the following formulas return the desired output..
In C4
=SUMIFS('Transaction Report'!O:O,'Transaction Report'!E:E,C$2,'Transaction Report'!G:G,$A4)
and then copy this formula to E4, G4 and I4.
In D4
=SUMIFS('Transaction Report'!Y:Y,'Transaction Report'!E:E,D$2,'Transaction Report'!Q:Q,$A4)
and then copy this formula to F4, H4 and J4.
In K4
=SUM(C4,E4,G4,I4)
In L4
=SUM(D4,F4,H4,J4)
and then select C2:L4 and copy down the rows.
Apr 01 2021 12:35 AM
* Example from the Internet and translated into English.
Hope I was able to help you with this info.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Apr 01 2021 01:01 AM
Apr 01 2021 01:03 AM
Apr 01 2021 04:19 AM
Apr 01 2021 12:34 AM
SolutionSee if the following formulas return the desired output..
In C4
=SUMIFS('Transaction Report'!O:O,'Transaction Report'!E:E,C$2,'Transaction Report'!G:G,$A4)
and then copy this formula to E4, G4 and I4.
In D4
=SUMIFS('Transaction Report'!Y:Y,'Transaction Report'!E:E,D$2,'Transaction Report'!Q:Q,$A4)
and then copy this formula to F4, H4 and J4.
In K4
=SUM(C4,E4,G4,I4)
In L4
=SUM(D4,F4,H4,J4)
and then select C2:L4 and copy down the rows.