phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

Excel Formula Help - Sum/Frequncy/If with multiple criteria

  • Posted:
  • Proposals: 3
  • Remote
  • #2356843
  • Awarded
Jason C.Islam A.Rahim A. have already sent a proposal.
  • 4

Description

Experience Level: Intermediate
I need to add a secondary (text) criteria (column H) to the following formula (or be shown another way) in order to count the number of unique bought items (Data!A:A) based on a) Month (Data!M;M) AND an additional criteria (Data!H:H) (Sales Region).

=SUM(--(FREQUENCY(IF(Data!M:M="august",Data!A:A),Data!A:A)>0))

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

    There are no clarification messages.