SOLVED

Help to find data with 3 criteria

Frequent Contributor

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.

5 Replies
best response confirmed by calof1 (Frequent Contributor)
Solution

@calof1 

See 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.

@calof1 

 

AAAA_INDEX_3_options.jpg

* 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.

 

Hi Subodh

thank you kindly for the help, works the way i wanted. Very much appreciated.
Hi Nikolino

thank you kindly for the help, i was able to adapt this to my spreadsheet and worked perfectly. Thanks for your hep, Very much appreciated.
You're welcome @calof1! Glad it worked as desired.