| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine Sumif and Countif
I need to combine sumif and countif. I am trying to add up data in a an area
say D1:O256 if it matches a criteria. Thats easy. Sumif. Then I want to divide that number and find the average of the sum. So I would sumif to get the total and sumifcountif the same area if the cell is greater than 1. Kinda confusing. Basic example below but I need to to be sum if and an additional "if" in countif. So the countif needs to be if it matches the requirements from the sumif. Need some help here. Probably an easy fix. Just lost =(SUMIF(QA!C3:O252,A3,QA!D3:O252))/(COUNTIF(D3:O3,"1")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine an AND and a COUNTIF | Charts and Charting in Excel | |||
| Can I combine CountIf with IF or AND? | Excel Discussion (Misc queries) | |||
| Help - I need to combine both a SUMIF and COUNTIF into one formula | Excel Worksheet Functions | |||
| Do I need to combine hlookup and countif????? | Excel Worksheet Functions | |||
| Combine Sumif | Excel Discussion (Misc queries) | |||
Threaded Mode
