Notifications
Clear all
Topic starter
hi guys
Kindly assist in answering the following from the attached
| 2. Who made more sales - person ending with ph or starting with je? |
|
3. What is the netsales for the person who had 6 customers?
Have an idea the functions in the topic name should be used
Regards
|
Posted : 17/01/2017 11:43 am
There is no attachment.
You need to click Add Files and then Start Upload to upload an attachment
Posted : 17/01/2017 11:49 am
Topic starter
HI
see attached xls file
Regards
Posted : 17/01/2017 12:25 pm
Hi Tererai
Try this
Q2 =IF(SUMIF(B4:B16,"*ph",D4:D16)>SUMIF(B4:B16,"je*",D4:D16),"ph","je")
Answer is ph
Q3 =SUMIF(C4:C16,6,D4:D16)
Answer is 1440
Sunny
Posted : 17/01/2017 12:47 pm
